Bug #2383 Sorting by danish letter æ,ø and å (ae, oe, aa)
Submitted: 14 Jan 2004 4:13 Modified: 22 Jan 2004 4:33
Reporter: Rene Truelsen Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.0.17 OS:Windows (Win2003 UK)
Assigned to: Alexander Barkov CPU Architecture:Any

[14 Jan 2004 4:13] Rene Truelsen 
Description:
When sorting records beginning with the danish letters æ, ø and å (ae, oe and aa) it sorts them wrong.
It sorts the alphabet as ...y,z,å,æ,ø  
the correct way is ...y,z,æ,ø,å

How to repeat:
Create a table (ID, name) and insert the 3 records : 
åse, 
øjvind, 
æg

do a select and "sort by name".
[15 Jan 2004 15:44] MySQL Verification Team 
Verified with 4.0.17. Thank you.
[16 Jan 2004 4:58] Alexander Barkov 
It looks like your mysql server is running in Swedish mode.
Please try the following:

SHOW VARIABLES LIKE 'char%';
[22 Jan 2004 4:33] Alexander Barkov 
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Additional info:

As no feedback, and it worked fine for
me with --default-character-set=danish,
I'm closing this bug.