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


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


I couldn’t find any doc in the mysql site. And I found this site to be helpful

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?


Maggie :)

Options: ReplyQuote

Subject Views Written By Posted
utf8 collation in mysql 39497 Maggie Pong 02/10/2005 04:15PM
Re: utf8 collation in mysql 12667 Alexander Barkov 05/07/2005 08:55AM
Re: utf8 collation in mysql 8845 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.