Bug #1799 Sorting alphabetically entries with Central European encoding

• Submitted: 10 Nov 2003 14:32
• Modified: 15 Nov 2003 1:47
• Reporter: [ name withheld ]
• Status: Can't repeat
• Category: MySQL Server: Command-line Clients
• Severity: S2 (Serious)
• CPU Architecture: Any

[10 Nov 2003 14:32] [ name withheld ]

Description:
I'm not sure this is the right cathegory but it's the closest I could think off.

At this part of the world we have some weird fonts: è, š, ž, æ, ð (I hope you could read it. if not, they're c, s, z with 'v' mark above them, c with '/' above it and d with '-' through the vertical line).

These are the characters that are not sorted correctly using 'order by ...' statement.

The correct order would be: a, b, c, (c with v), (c with /), d, (d with -), ..., r, s, (s with v), t, ..., x, y, z, (z with v).

I am sure about all above but c with / above it, since our alphabet doesnt use it (but our southern neighbours do).

These letters show up as empty squares on my screen as i browse the database (with phpmyadmin), but that's the problem with my encoding settings. I can see though they're not sorted alphabetically as they should have been.

How to repeat:
i'm not sure what to type here but i supose i have to type something :)

[15 Nov 2003 1:47] Alexander Keremidarski

Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.mysql.com/how-to-report.php

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.

What you should type in How-to-repeat is How to repeat the problem.

Most important part in your case is what MySQL release to use and what character set (or sets) you have configured.

MySQL supports Central European encoding as server startup parameter in 3.23 and 4.0 

In 4.1 there are server, database, table, column default character sets along with various Collations