Re: mysql can not to insert unicode16 uncommon word
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.
Subject
Views
Written By
Posted
4890
May 13, 2013 02:27AM
1901
May 13, 2013 09:16PM
1849
May 14, 2013 09:07PM
1733
May 15, 2013 08:03PM
1691
May 16, 2013 01:48AM
Re: mysql can not to insert unicode16 uncommon word
2159
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.