Home » Developer & Programmer » JDeveloper, Java & XML » Problem With Xml query (Oracle 10.2.0.3.0)
Problem With Xml query [message #297371] Thu, 31 January 2008 04:54 Go to next message
trivendra
Messages: 211
Registered: October 2007
Location: Phoenix
Senior Member
I have a data which is Japanese Names. I have Created a table with two columns to insert the data in these columns.

When the data is inserted then select query fires correct result, but when i use the XML the data get corroupt.

NLS_CHARACTERSET is 'AL32UTF8'

SQL> CREATE TABLE JAP_NM_TEST
  2  (
  3    KANJI_NM  VARCHAR2(500 BYTE),
  4    KANA_NM   VARCHAR2(500 BYTE)
  5  );

Table created.

SQL> insert into JAP_NM_TEST values('タナカ トモナリ','タナカ トモナリ');

1 row created.

SQL> commit;

Commit complete.

SQL> select * from JAP_NM_TEST;

KANJI_NM	KANA_NM
------------ ------------
タナカ トモナリ       タナカ トモナリ


SQL> -- What if when we select this data is xml
SQL> -- The Data get corroupt
SQL> SELECT (XMLFOREST (XMLELEMENT ("names", XMLELEMENT ("KanjiNm", a.kanji_nm)) AS "NM").getclobval ()) AS SQLDATA
  2    FROM jap_nm_test a;

SQLDATA
--------------------------------------------------------------------------------
<NM><names><KanjiNm>・スナカ ・ス・ス</KanjiNm></names></NM>

Re: Problem With Xml query [message #297372 is a reply to message #297371] Thu, 31 January 2008 04:58 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
I think you should post this in Japanese Forum.
Do you agree I move it there.
Or I could also move it to XML forum.

Regards
Michel
Re: Problem With Xml query [message #297375 is a reply to message #297371] Thu, 31 January 2008 05:04 Go to previous messageGo to next message
trivendra
Messages: 211
Registered: October 2007
Location: Phoenix
Senior Member
This will great if you do so..
Thanks
Trivendra
Re: Problem With Xml query [message #297379 is a reply to message #297375] Thu, 31 January 2008 05:15 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Which one? Japanese or XML?
I admit I don't know in which one you will likely get an answer.

Regards
Michel
Re: Problem With Xml query [message #297383 is a reply to message #297371] Thu, 31 January 2008 05:24 Go to previous message
trivendra
Messages: 211
Registered: October 2007
Location: Phoenix
Senior Member
That's ok.
make it to XML forum.

Thanks and Regards
Trivendra
Previous Topic: ADF: HowTo Update a table without changing the current row
Next Topic: Jdeveloper(ADF query)
Goto Forum:
  


Current Time: Thu Nov 21 23:55:25 CST 2024