"G B U" <[EMAIL PROTECTED]> wrote: > Recently I've come around that mysql (4.1.0 at least) treats different > queries containing non-english characters (in my case characters from > cp1251 charset) as the same query and therefore returns wrong results. > For example the following queries are regarded as identical while they are not: > SELECT FROM table WHERE name LIKE 'при%' > SELECT FROM table WHERE name LIKE 'про%' > > Is this a bug or expected behaviour?
If you use 4.0.x or 3.23.xx version check that MySQL server uses cp1251 with SHOW VARIABLES LIKE "character_set" statement. If you use 4.1.x version check that column name has cp1251 character set. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]