By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,237 Members | 1,224 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,237 IT Pros & Developers. It's quick & easy.

DB2 XQUERY can't serialize unicode string??? STATE 2200W

P: n/a
xquery
for $y in
db2-fn:xmlcolumn('MYTABLE.DATAXML')/DataXML/MLData/Gr/LongDescription
return $y

Works fine if LongDescription contains only english... if I use greek
for example.. I get

SQL0969N There is no message text corresponding to SQL error "-20412"
in the
message file on this workstation. The error was returned from module
"SQLABOLB" with original tokens "". SQLSTATE=2200W

SQL10007N Message "20412" could not be retrieved. Reason code: "4".

SQLSTATE 2200W: An XML value contained data that could not be
serialized.

Any help would be great!

Vasili

Sep 24 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Vasili,

are you running the query from the command line? If yes, you get this
error because Double Byte Character Set is not supported for the
command line mode.

If you run the query from the DB2 Developer Workbench or Control
Center, you should be able to see the correct output.

Vitor

Oct 12 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.