Re: UTF8 Chinese String Comparison
Posted by: Rick James
Date: September 26, 2009 05:48PM

What program is being used for these tests? Are you executing SET NAMES utf8 immediately after connecting?

Suggest setting the default collation on the table to utf8_unicode_ci (not general).

Please use HEX(a) to display the values in the table. Too many things are potentially fiddling with the characters on their way to this UI. And perhaps use UNHEX(...) to provide us with the test strings for further analysis.

Options: ReplyQuote


Subject
Views
Written By
Posted
9877
September 25, 2009 01:38PM
Re: UTF8 Chinese String Comparison
3441
September 26, 2009 05:48PM
3121
September 27, 2009 12:37PM
4286
September 27, 2009 05:44PM
3320
September 28, 2009 03:41PM
3542
September 28, 2009 03:49PM
3046
September 28, 2009 11:41PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.