Bug #8211 utf8 romanian collation: wrong sort order
Submitted: 31 Jan 2005 12:59 Modified: 5 Feb 2005 8:33
Reporter: [ name withheld ] Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.1.9 OS:Windows (Winows XP)
Assigned to: CPU Architecture:Any

[31 Jan 2005 12:59] [ name withheld ]
Description:
sorting order in romaniana, using utf8 romanian collation is wrong in the case of ţ.

How to repeat:
just activate utf8 and utf8 romanian collation and do a select with order by a column

Suggested fix:
ţ must be after t and before u.
[5 Feb 2005 8:33] Aleksey Kishkin
mysql> select version();
+-----------+
| version() |
+-----------+
| 4.1.9-max |
+-----------+
1 row in set (0.00 sec)

mysql> show create table bug8211 \G
*************************** 1. row ***************************
       Table: bug8211
Create Table: CREATE TABLE `bug8211` (
  `a` char(10) collate utf8_romanian_ci default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_romanian_ci
1 row in set (0.00 sec)

mysql> select * from bug8211 order by a \G
*************************** 1. row ***************************
a: t
*************************** 2. row ***************************
a: ┼г
*************************** 3. row ***************************
a: u
3 rows in set (0.00 sec)
[5 Feb 2005 8:35] Aleksey Kishkin
Grrrrr. unicode conversations, during copy&paste.
result set is:

't'
'ţ'
'u'