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

vasilip

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

Subscribe Post Reply

1447

Serge Rielau

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

vasilip

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

Similar topics

unicode string literals and "u" prefix

by: nico | last post by:

In my python scripts, I use a lot of accented characters as I work in french. In order to do this, I put the line # -*- coding: UTF-8 -*- at the beginning of the script file. Then, when I need...

Python

Unicode string in exec()

by: Shrii | last post by:

1.I read a unicode file by using codec 2.I want to pass that string to exec() statement 3.But one of my character (U+0950) in that string is not showing properly in the output got by that exec()...

Python

How do i convert unicode string to ansi string in C#?

by: Julia | last post by:

Hi, I need to convert unicode string to ansi string Thanks in adavance.

C# / C Sharp

decode unicode string using 'unicode_escape' codecs

by: aurora | last post by:

I have some unicode string with some characters encode using python notation like '\n' for LF. I need to convert that to the actual LF character. There is a 'unicode_escape' codec that seems to...

Python

Unable to serialize the session state

by: js | last post by:

Does anybody knows how to solve the problem? I added attribute to the following classes in Microsoft.Practices.EnterpriseLibrary.Data namespace, but I still get the error. Thanks. ...

ASP.NET

Can I get the 8bit-string representation of any unicode string

by: wanghz | last post by:

Hello, everyone. I have a problem when I'm processing unicode strings. Is it possible to get the 8bit-string representation of any unicode string? Suppose I get a unicode string: a =...

Python

Unable to serialize the session state.

by: Tim | last post by:

Could anyone tell me what this means and how do I correct it. Any suggestions? Thanks! Tim Richardson IT Developer and Consultant www.paladin3d.com Unable to serialize the session state. In...

.NET Framework

byte count unicode string

by: willie | last post by:

>willie wrote: wrote:

Python

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

by: vasilip | last post by:

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 ...

DB2 Database

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice