XMLTYPE and International Characters

From: Iblix <iblix_at_yahoo.com>
Date: 19 Jan 2004 12:27:45 -0800
Message-ID: <a8687af5.0401191227.287580dd@posting.google.com>

Database: Oracle9i
Characterset: US7ASCII

I am trying to insert a very small xml document into an XMLTYPE column in a table.

My xml document, however, contains international characters like French and Spanish letters with their accompanying accent marks.

I have tried setting various encoding schemes in the encoding attribute on the xml document but none of them work.

The parser stops at the first international character and complains that it is invalid.

Is there anything I can do to insert these characters into my XMLTYPE column without complaint?

Thanks. Received on Mon Jan 19 2004 - 14:27:45 CST