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';