[DB2 V9] Problem with Unicode in XML fields

[Piotr 'Zenobius' Baranowski]

Hello

I'm using DB2 Express-C V9 with FixPack2 on CentOS.
I have database created with territory PL.
I'm using it with WebApplication written in PHP, the pages are encoded in
UTF-8.

I'm writing some data to XML, that contains polish characters. And that's
where problem begins ;-)
It's encoded with some crazy charset and products buggy chars.
When it's nonpolish chars it's ok, it's screwing up when there're some
polish chars.

Did anybody encountered such problem?
I think it's true to other not standard characters.

TIA for help.
--
Best regards,
Piotr Baranowski

[Vijay Bommireddipalli]

On Jun 15, 9:19 am, Piotr 'Zenobius' Baranowski
<[e-mail]:

Hello

I'm using DB2 Express-C V9 with FixPack2 on CentOS.
I have database created with territory PL.
I'm using it with WebApplication written in PHP, the pages are encoded in
UTF-8.

I'm writing some data to XML, that contains polish characters. And that's
where problem begins ;-)
It's encoded with some crazy charset and products buggy chars.
When it's nonpolish chars it's ok, it's screwing up when there're some
polish chars.

Did anybody encountered such problem?
I think it's true to other not standard characters.

TIA for help.
--
Best regards,
Piotr Baranowski

Did you try entering the XML data from the command line ?
Does that work (with Polish characters) ?

[Jan M. Nelken]

Piotr 'Zenobius' Baranowski wrote:

Hello

I'm using DB2 Express-C V9 with FixPack2 on CentOS.
I have database created with territory PL.
I'm using it with WebApplication written in PHP, the pages are encoded in
UTF-8.

Silly question: did you create database in Unicode?

Jan M. Nelken

[frodo2000]

On Jun 15, 6:19 pm, Piotr 'Zenobius' Baranowski
<[e-mail]:

Hello

I'm using DB2 Express-C V9 with FixPack2 on CentOS.
I have database created with territory PL.
I'm using it with WebApplication written in PHP, the pages are encoded in
UTF-8.

I'm writing some data to XML, that contains polish characters. And that's
where problem begins ;-)
It's encoded with some crazy charset and products buggy chars.
When it's nonpolish chars it's ok, it's screwing up when there're some
polish chars.

Did anybody encountered such problem?
I think it's true to other not standard characters.

TIA for help.
--
Best regards,
Piotr Baranowski

Hello,

You have to open db2cmd and type: db2set db2codepage=1208 This setting
avoid convertion of DB2 charset (if you prepare database for XML, DB2
always set UTF-8 encoding) to system charset.

Marcin Molak

[Piotr 'Zenobius' Baranowski]

Dnia Sat, 16 Jun 2007 16:01:51 -0400, Jan M. Nelken napisał(a):

Piotr 'Zenobius' Baranowski wrote:

>Hello

I'm using DB2 Express-C V9 with FixPack2 on CentOS.
I have database created with territory PL.
I'm using it with WebApplication written in PHP, the pages are encoded in
UTF-8.

Silly question: did you create database in Unicode?

Yep, i had to. XML type requires that :-)

--
Pozdrawiam bądź nie.. [ GG# 997057 ]
Piotr Baranowski
Owiec Hardcore'u z Generacji-D
Zenobius Hermenegildorf Xavierus 'Korpuskularny'

[Piotr 'Zenobius' Baranowski]

Did you try entering the XML data from the command line ?

Does that work (with Polish characters) ?

I've entered it thru Workbench and it worked well.

--
Best regards.. or not..
Piotr Baranowski
Owiec Hardcore'u z Generacji-D
Zenobius Hermenegildorf Xavierus 'Korpuskularny'

[Piotr 'Zenobius' Baranowski]

Hello,

>
You have to open db2cmd and type: db2set db2codepage=1208 This setting
avoid convertion of DB2 charset (if you prepare database for XML, DB2
always set UTF-8 encoding) to system charset.

Marcin Molak

Thanks, that was the problem.

--
Best regards,
Piotr Baranowski
Owiec Hardcore'u z Generacji-D
Zenobius Hermenegildorf Xavierus 'Korpuskularny'

[Vijay Bommireddipalli]

Thanks, that was the problem.

be careful with that setting though. DB2 will assume all data being
fed to it is UTF8 and any other applications that rely on system code
page conversion from system charset to UTF8 will not work correctly.