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: | |
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 ]
[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'