Cyber SZ writes: > >Description: > Following is the test reproduced in several databases (tables of around 7 > millions records). Mysql compiled with GBK charset. > A select used with a like 'alpha%' condition fails to report exact matches. > Even if the select is completed by an "OR" field = 'alpha', it does not > work. > This is shown afterwards on latin characters, but the problem is exactly the > same on Chinese characters. >
[skip] Hi! Can you please try our latest 3.23 binary and see if the problem reccurs. It could be a bug fixed long time ago. If it does reccur, please let us know and we shall let you know how to upload your table. -- Regards, __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com --------------------------------------------------------------------- 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