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

(CORRECTION!) DB2 XQUERY can't serialize unicode string??? STATE 2200W

P: n/a
THIS ONLY HAPPENS WHILE QUERYING IN THE CONTROL CENTER. is there anyway
to get around this? the query works fine if I query from java for
example.

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

SQLSTATE 2200W: An XML value contained data that could not be
serialized.
Any help would be great!
Vasili

Sep 25 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
vasilip wrote:
THIS ONLY HAPPENS WHILE QUERYING IN THE CONTROL CENTER. is there anyway
to get around this? the query works fine if I query from java for
example.
Just to get an additional data point:
Have you tried Developer Work Bench (DWB)?

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/
Sep 25 '06 #2

P: n/a
No, I havent.. I am downloading it now..

I just went through the tutorial on it while waiting.. seems it will
make my life much easyer.

Thanks for the tip.. as well as for your help in clearing up my
XML/Spatial data table modification issue.

much obliged for your prompt and useful responces.

Vasili

Serge Rielau wrote:
vasilip wrote:
THIS ONLY HAPPENS WHILE QUERYING IN THE CONTROL CENTER. is there anyway
to get around this? the query works fine if I query from java for
example.
Just to get an additional data point:
Have you tried Developer Work Bench (DWB)?

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/
Sep 25 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.