utf8 collation in mysql
Posted by: Maggie Pong
Date: February 10, 2005 04:15PM

Hi,



I am trying to figure out how each of the following collation sort alphabets in mysql:


utf8_general_ci
utf8_unicode_ci
utf8_spanish_ci
utf8_swedish_ci


I couldn’t find any doc in the mysql site. And I found this site to be helpful http://developer.mimer.com/collations/charts/index.tml

However, when I cross check the Swedish collation which supposed to treat v and w the same, mysql’s utf8_swedish_ci thinks that they are different.

Basically, I would like to find out if storing data in utf8, which collation I should use for various languages such as French, Spanish, German, Italian …etc.

Also, I don’t see a utf8 collation for German in mysql. I only see one under latin1, does that mean I have to use latin1 encoding if I need to support German?

Thanks,


Maggie :)

Options: ReplyQuote


Subject
Views
Written By
Posted
utf8 collation in mysql
39550
February 10, 2005 04:15PM
12680
May 07, 2005 08:55AM
8859
July 14, 2005 12:46AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.