Chinese sorting problem of character set utf8
Database
Character set: utf8
Collation: utf8_generay_ci
Table structure:
Mysql > desc chr
+-+ +
| | Field | Type | Null | Key | Default | Extra | |
+-+ +
| | char_1 | char (255) | YES | | NULL |
| | bin | varbinary (20) | YES | | NULL |
| | name | varchar (50) | YES | | NULL |
| | static_bin | binary (30) | YES | | NULL |
+-+ +
Chinese sorting will be out of order:
Mysql > select * from chr order by name
+-+
| | char_1 | bin | name | static_bin | |
+-+
| | No |
| | he |
| | send Safin |
| | Ah |
| | A |
| | Uh, hungry |
+-+
6 rows in set (0.01 sec
Mysql > select * From chr order by convert (name using 'gbk') collate' gbk_chinese_ci'
->
+-+
| | char_1 | bin | name | static_bin | |
+-+
| | A |
| | Ah |
| | No |
| | Uh, hungry |
| | send Safin |
| | he |
+-+
6 rows in set (0.00 sec)
Mysql >