Hello, There's a problem with mysql query, which I would like to report to all of you. I'm not sure if it can be taken as a "bug" though.
Suppose we have a very simple table with only three or four fields. Let's say the table is "employee", and one of the fields is "name" in varchar or char type. Suppose all the names stored in the "name" are just one single Chinese character. We have following very simple queries applying on the table described as above: select * from employee where name="[a Chinese character]"; or, select * from employee where name like "%[a Chinese character]%"; As supposed, mysql should pickup only one record from the table with a certain query. However, for some of the Chinese characters, mysql can't tell the difference thus it pickup more than one records from the table. We have found two groups of Chinese characters which MySQL can not differentiate. I list them as bellow, where each Chinese character is expressed as two Hex code: 1. C0EE, C0CF 2. CDF5, CFF3, CDF3 This problem was found on 3.23.36 and 3.23.43. The test was taken on RH 7.1, and was taken from phpmyadmin, terminal and php script, and got same result. Please, if anyone here happen to know this issue, help me out. Thanks in advance! Regards, Alex Shi --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
