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
9857
September 25, 2009 01:38PM
Re: UTF8 Chinese String Comparison
3432
September 26, 2009 05:48PM
3119
September 27, 2009 12:37PM
4282
September 27, 2009 05:44PM
3314
September 28, 2009 03:41PM
3538
September 28, 2009 03:49PM
3043
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.