XML Database (MOSC)

MOSC Banner

How to load an utf8-encoding XML file into a relational table in oracle 10g

edited Jan 14, 2010 4:20AM in XML Database (MOSC) 2 commentsAnswered
  How to load an utf8-encoding XML file into a relational table in oracle 10g

I want to load an utf8-encoding XML file into a table,but the data would be converted into garbage data when i use dbms_XMLSave.Maybe it's a question of mismatching between character sets. the detail specification is as follows:

my unix enviroment:

      LANG =en_US.utf8

my oracle character set:

     NLS_CHARACTERSET = WE8ISO8895P1

     NLS_NCHAR_CHARACTERSET = AL16UTF16

    NLS_LANG = america_american.utf8

my sql/plus produre:(just XML relative part is listed here)

    。。。

    indoc varchar(255);

    name varchar(255);

    dlob   CLOB;

   indoc:='/tmp/load.xml';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center