Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

To be (UTF-8) or not to be

flaviocMar 6 2007 — edited Mar 4 2011

Hi,
i've got a file containing unicode character FFFD.
According to Unicode this is a sort of placeholder for an unknown character.
The file is encoded in UTF-8, however oracle won't load it.
Now my question is: is this weirdo a valid UTF-8 character or not in the end?

Just because when i try to load an xml file encoded as UTF-8 into Oracle, it throws me the following exception:

ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00200: could not convert from encoding UTF-8 to UCS2
Error at line 1931

Thanks,
Flavio

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 1 2011

Added on Mar 6 2007

#performance-availability, #xml, #xml-db

13 comments

5,273 views