Re: mysql can not to insert unicode16 uncommon word
Posted by: Rick James
Date: May 16, 2013 09:02PM

http://www.charbase.com/22222-unicode-invalid-character

Notice how UTF16 (not utf8), Java, and Javascript break it into two codes. This is because they can't go beyond 16 bits per character. (Similarly, MySQL's utf8 does not go past 3 bytes per character.)

I suggest that your 'D848DE22' came from utf16 or some program that uses utf16 (Java, etc). Please investigate the source.

The 'BF' at the start of 'BFF0A288A2' sounds wrong; the rest of the encoding matches U+22222.

22222 sounds suspicious, but it seems to be a real character.

Back to MySQL... I would expect 'F0A288A2' to work fine in the utf8mb4 CHARACTER SET.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: mysql can not to insert unicode16 uncommon word
1926
May 16, 2013 09:02PM


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.