Bug #3224 LIKE with cyrillic works wrong

• Submitted: 18 Mar 2004 8:47
• Modified: 20 Mar 2004 16:40
• Reporter: Valery Makarenko
• Status: Not a Bug
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5
• OS: Linux (Linux/windows)
• CPU Architecture: Any

[18 Mar 2004 8:47] Valery Makarenko

Description:
Аfter upgraing MySQL 3.23 to 5.0a 
Like becomes work wrong with cyrillic strings in win1251 coding

e.g. russian char 'б'(sounds like b) is equal to any russian chars

The same thing is with function LOCATE

How to repeat:
SELECT 'д' Like 'б'

[20 Mar 2004 16:40] Alexander Keremidarski

Sorry, but the bug system is not the appropriate forum for asking
support questions. Your problem is not the result of a bug.
For a list of more appropriate places to ask for help using MySQL
products, please visit http://www.mysql.com/support/

Thank you for your interest in MySQL.

Additional info:

MySQL 5.0 inherits full Character Sets and Collation support from 4.1 where it was introduced.

There are lot of pages in Manual explaining what it is about and I can ensure you 5.0 works perfect not only with Cyrillic which I use everyday, but with different languages too.

mysql> show collation like 'cp1251%';
+---------------------+---------+----+---------+----------+---------+
| Collation           | Charset | Id | Default | Compiled | Sortlen |
+---------------------+---------+----+---------+----------+---------+
| cp1251_bulgarian_ci | cp1251  | 14 |         |          |       0 |
| cp1251_ukrainian_ci | cp1251  | 23 |         |          |       0 |
| cp1251_bin          | cp1251  | 50 |         |          |       0 |
| cp1251_general_ci   | cp1251  | 51 | Yes     |          |       0 |
| cp1251_general_cs   | cp1251  | 52 |         |          |       0 |
+---------------------+---------+----+---------+----------+---------+