Re: UTF8 Chinese String Comparison

[CL Chuah]

Hi Rick,
U r indeed an expert! Like what u suspected, the input is 'contaminated', i only found out when i use HEX() function that u suggested. And yes, the records are double encoded.

So the lesson is: "SET NAMES utf8" is a MUST right from the beginning when the records are inserted.

For the benefit of those hitting the same problems, here are simple flows:
SET NAMES utf8; -- Don't forget this
insert into test_utf (a) values ('飞');
insert into test_utf (a) values ('裎');

And when u retrieve records,
SET NAMES utf8; -- Again, Don't forget this
select * from test_utf where a='裎';
> The server returns what I wanted '裎'

Thanks again!



Edited 1 time(s). Last edit at 09/28/2009 03:51PM by CL Chuah.