Bug #3224 LIKE with cyrillic works wrong
Submitted: 18 Mar 2004 8:47 Modified: 20 Mar 2004 16:40
Reporter: Valery Makarenko Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5 OS:Linux (Linux/windows)
Assigned to: 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 |
+---------------------+---------+----+---------+----------+---------+