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
10488
September 25, 2009 01:38PM
Re: UTF8 Chinese String Comparison
3647
September 26, 2009 05:48PM
3296
September 27, 2009 12:37PM
4526
September 27, 2009 05:44PM
3553
September 28, 2009 03:41PM
3784
September 28, 2009 03:49PM
3275
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.