Re: Unicode collation, utf8 data fetch/manip problem
Posted by:
Rick James
Date: April 22, 2010 09:26PM
I'll guess you have "double encoding". This happens when the program doing the INSERT has the bytes in one encoding, but tells MySQL (via SET NAMES and/or | character_set_client and character_set_connection, not by a collation_connection) a different thing.
Note: MySQL's utf8 implementation cannot generate more than 3 bytes for a given character.
Please SELECT HEX(x) ... so we can see what those characters got encoded as. And, please provide the 'correct' utf8 representation of them.
Subject
Views
Written By
Posted
7669
April 12, 2010 07:18PM
Re: Unicode collation, utf8 data fetch/manip problem
2524
April 22, 2010 09:26PM
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.