Help RUSSIAN programmer! Problem in characters comparison.
Posted by: Dmitry Libertas
Date: March 27, 2005 12:24PM

Dear MySQL experts!

I'm a russian programmer... And I have a problem with storing russian text in MySQL 4.1.10. This problem follow me in all 4.1.x. I try to store information in Windows Cyrillic cp1251. And when I use default collation cp1251_general_ci there is a problem in characters comparison. For instance, in mysql.exe shell-window try to type:

set names cp1251;
select 'b' = 'v';

Where symbol 'b' and 'v' is a native russian symbol (I transliterate this characters). The server answer is '1', i.e. symbol 'b' and 'v' is equal! It's impossible! This only a demonstration of the problem. In real situations I avoid the russian text in MySQL 4.1.x, because even in "char(1), unique" field I can't store simple russian alphabet. MySQL wouldn't take its symbols - they think that (for expamle) 'b' = 'v'.

Another problem, is "LIKE" statement. When I store english text, LIKE statement is case-independent. But when russian - LIKE is case-dependent.

Of course, when I use cp1251_bin (or koi8r_bin) I haven't problem in symbols comparison. But this is not satisfactory decision...

Please, help russian programmer! My chief don't wait much... :)
Thanks! Sorry for my terrible english...

King regards, Dmitry Libertas.

Options: ReplyQuote


Subject
Views
Written By
Posted
Help RUSSIAN programmer! Problem in characters comparison.
4703
March 27, 2005 12:24PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.