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.
Subject
Views
Written By
Posted
10541
September 25, 2009 01:38PM
Re: UTF8 Chinese String Comparison
3670
September 26, 2009 05:48PM
3313
September 27, 2009 12:37PM
4546
September 27, 2009 05:44PM
3571
September 28, 2009 03:41PM
3810
September 28, 2009 03:49PM
3291
September 28, 2009 11:41PM
Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.
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.