Bug #7072 | wrong sort order for russian characters in ut8 charset | ||
---|---|---|---|
Submitted: | 7 Dec 2004 12:47 | Modified: | 7 Dec 2004 13:28 |
Reporter: | [ name withheld ] | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server | Severity: | S3 (Non-critical) |
Version: | 4.1.7 | OS: | Linux (Linux) |
Assigned to: | CPU Architecture: | Any |
[7 Dec 2004 12:47]
[ name withheld ]
[7 Dec 2004 13:28]
Alexander Keremidarski
Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://www.mysql.com/documentation/ and the instructions on how to report a bug at http://bugs.mysql.com/how-to-report.php Additional info: utf8_general_ci collation is Accent Insensitive and therefore "yo" = "ye" according to it. Letters with same sorting weight are sorted in random order . cp1251 is Accent Sensitive that's why it sorts "yo" after "ye" mysql> SET NAMES utf8; SELECT 'е' = 'ё'; Query OK, 0 rows affected (0.00 sec) +-------------+ | 'е' = 'ё' | +-------------+ | 1 | +-------------+ 1 row in set (0.00 sec) mysql> SET NAMES cp1251; SELECT 'е' = 'ё'; Query OK, 0 rows affected (0.00 sec) +-------------+ | 'е' = 'ё' | +-------------+ | 0 | +-------------+ 1 row in set (0.00 sec)