Page 1 of 2
What's so great about latin1_swedish_ci
Posted: Tue Jul 26, 2005 11:59 am
by Ambush Commander
I tried googling for it but alas, to no avail. CI = case insensitive, so that makes sense, but why Swedish Latin?
Posted: Tue Jul 26, 2005 1:11 pm
by onion2k
Never worked that out myself. But having such a weird default is a good reminder to change it, so I'm not complaining.
Posted: Tue Jul 26, 2005 1:14 pm
by Ambush Commander
So you "should" change it?
Re: What's so great about latin1_swedish_ci
Posted: Tue Jul 26, 2005 4:31 pm
by Roja
Ambush Commander wrote:I tried googling for it but alas, to no avail. CI = case insensitive, so that makes sense, but why Swedish Latin?
Where do you see latin1_swedish_ci ?
Posted: Tue Jul 26, 2005 11:47 pm
by pilau
Collation column on a string key row in a DB table.
Posted: Tue Jul 26, 2005 11:57 pm
by Roja
pilau wrote:Collation column on a string key row in a DB table.
Odd.. I guess Fedora, Redhat, and OpenBSD fix that before packaging, as I've never encountered it.
Posted: Wed Jul 27, 2005 12:11 am
by pilau
Roja wrote:Fedora, Redhat, and OpenBSD fix that before packaging
What are these?
Posted: Wed Jul 27, 2005 1:12 am
by Roja
pilau wrote:Roja wrote:Fedora, Redhat, and OpenBSD fix that before packaging
What are these?
Operating systems that I use, which have packages for mysql.
Posted: Wed Jul 27, 2005 2:06 am
by pilau
Ok. Is there anything special about them?
Posted: Wed Jul 27, 2005 3:05 am
by onion2k
I think it's only the default on the Windows binary of MySQL. Maybe that's compiled by a Swedish person.
As for changing it, I always set my databases to utf8_unicode_ci .. but most of the sites I write have some internationalised elements these days. Strictly speaking you should set the collation and charset to whatever language your content is going to be.
Posted: Wed Jul 27, 2005 5:55 am
by Chris Corbyn
pilau wrote:Ok. Is there anything special about them?
They're all linux based systems

Posted: Wed Jul 27, 2005 6:07 am
by Roja
d11wtq wrote:pilau wrote:Ok. Is there anything special about them?
They're all linux based systems

Not OpenBSD!

Posted: Wed Jul 27, 2005 6:09 am
by Roja
pilau wrote:Ok. Is there anything special about them?
I only mentioned them because no one had mentioned on what platform they were seeing this oddball setting, and I had never experienced it. On the platforms I had used (OpenBSD, Redhat, Fedora), that setting isn't used.
I was trying to help clarify where the problem was, essentially.
Posted: Wed Jul 27, 2005 6:33 am
by pilau
I'm having the same thing but with MySQL 3.2, each time I create a new CHAR or VARCHAR or TEXT key it sets it's collation as 'latin1_swedish_ci'.
Posted: Wed Jul 27, 2005 6:35 am
by Chris Corbyn
Of course, unless your system's package manager is changing the settings you most likely get the default collation as latin1_swedish_ci
Last install of MySQL 4 on Gentoo and SuSE both gave me this default
