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.

Options: ReplyQuote

Written By
Re: Unicode collation, utf8 data fetch/manip problem
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.