Skip navigation links

MySQL Forums :: Character Sets, Collation, Unicode :: utf8 collation in mysql


Advanced Search

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 37254 Maggie Pong 02/10/2005 04:15PM
Re: utf8 collation in mysql 12236 Alexander Barkov 05/07/2005 08:55AM
Re: utf8 collation in mysql 8525 Michael Bunge 07/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.