MySQL Bugs: #23628: Utf8 collation returns wrong order when using greek

Bug #23628	Utf8 collation returns wrong order when using greek
Submitted:	25 Oct 2006 14:06	Modified:	25 Oct 2006 20:18
Reporter:	Apostolos Pantsiopoulos	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	5.0.24a	OS:	Linux (FC3)
Assigned to:		CPU Architecture:	Any

Description:
I am using utf8 for everything in my server.
I have a table that some of its values are in greek.
When I am using a slect ... order by ... query I get the result set in wrong order.
Most specifically I get :

1. All A-G latin data
2. All greek data in wrong order
3. The rest of the latin data

I used a perl cgi script, the mysql client, Navicat fornt end. They all gave me the same results.

My collation defaults to utf8_general_ci.

How to repeat:
Create a table that uses utf8 charset and collation.
Insert some greek and latin words.
Do a select ... from .. order by .... statement

Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Please read carefully about collations for Unicode data at http://dev.mysql.com/doc/refman/5.0/en/charset-unicode-sets.html