I am attempting to use the new UTF8 collations in MySQL 4.1.3 to perform case-insensitive, accent-insensitive sorting. Based on the example in section 11.3.13 of the manual (http://dev.mysql.com/doc/mysql/en/Charset-collation-effect.html ) I expect M(u-diaeresis)ller to sort after MX Systems in the following:
mysql> SELECT col2 FROM test ORDER BY col2 COLLATE utf8_swedish_ci; +------------+ | col2 | +------------+ | M(u-diaresis)ller | | Muffler | | MX Systems | | MySQL | +------------+ I have tried various UTF8 collations and, apart from utf8_bin, they all place M(u-diaresis)ller at the start. Is there a bug in the utf8_swedish_ci collation or am I using it incorrectly? (NOTE: To avoid problems with email clients, I have changed all occurances of the character in question to (u-diaresis) in this message but it is represented correctly in the database.) Thanks, Jody -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]