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