Re: UTF8 Chinese String Comparison

[CL Chuah]

Thks Rick.

I'm using SQLyog to do the test. Actually it was part of bigger project develop in PHP, i extract portion of it.

And yes, I tested using SET NAMES utf8 before, here is test result
set names utf8;
select * from test_utf where CONVERT(a USING gb2312)=CONVERT('飞' USING gb2312); -- return nil
select * from test_utf where a='裎'; -- return nil

if I change it to
set names latin1;
select * from test_utf where CONVERT(a USING gb2312)=CONVERT('飞' USING gb2312); -- return what i want
select * from test_utf where a='裎'; -- return both records

Will try the HEX() and let u know the result.