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 ;)