Bug #10790 ordering not using collation provided by (unicode) locale
Submitted: 22 May 2005 17:32 Modified: 7 Jun 2005 23:21
Reporter: Denis Jacquerye Email Updates:
Status: Closed Impact on me:
Category:MySQL Server Severity:S3 (Non-critical)
Version: OS:Linux (Linux)
Assigned to: CPU Architecture:Any

[22 May 2005 17:32] Denis Jacquerye
Several languages use caracters combined with diacritics. These caracters are not sorted properly.

For example the word ñoño will be found after all the z*, but it should be between all the n* and the o* if the locale is es.
It would also be useful to be able to set the level of comparison (L1, L2,...).

How to repeat:
Order text that is using accented caracters.

Suggested fix:
Support Unicode Multi-Level comparison and locales
[22 May 2005 19:22] Sergei Golubchik
Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at

If you can provide more information, feel free to add it
to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.

Additional info:

"Unicode Multi-level comparison" is supported.
You need to provide a complete repeatable test case (and specify your MySQL version too), if you think it does not work as it should.
[7 Jun 2005 23:21] Denis Jacquerye
The version of MySQL I was using was old, the latest version does handle locales for string collation properly. Thanks