Hello,

I want to store my data with UTF8, thus I'm using the utf8 charset for my tables. But which collcation shall I use? I cannot find anything appropriate.

I cannot use utf8_unicode_ci or utf8_general_ci, because this seems to treat "Ä" and "A" equally. So I couldn't store the words "ÄBC" and "ABC" in the same index.

On the other hand I cannot use utf8_bin, because it doesn't sort correctly (as people in Germany would expect it, Ä = Ae).

So, whats left?

Regards
Marten

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to