Problem putting rare Chinese characters into a UTF8 field
Posted by: Benoni Hamilton
Date: December 17, 2009 04:48AM

Hey,

I have a database with a column "traditional" which uses the UTF-8 character set. All is normally fine, but if I insert a rare character then it errors out. I have had this in the past, but it's only just annoyed me today as I must be able to use this string. So which this has happened with other characters in the past, I can only give this example.

Query: UPDATE zi_1 SET trad = "𥁕" WHERE id = 6422

Error: 1366 Incorrect string value: '\xF0\xA5\x81\x95' for column 'trad' at row 1

F0 A5 81 95 is the correct UTF8 code for this character, see http://www.unicode.org/cgi-bin/GetUnihanData.pl?codepoint=25055&useutf8=false

Can anyone provide any pointers to a solution?

Cheers,

Benoni

Options: ReplyQuote


Subject
Views
Written By
Posted
Problem putting rare Chinese characters into a UTF8 field
3854
December 17, 2009 04:48AM


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.