dbTalk Databases Forums  

Perl DBI and Various Codepages

comp.databases.ibm-db2 comp.databases.ibm-db2


Discuss Perl DBI and Various Codepages in the comp.databases.ibm-db2 forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Dana Cordes
 
Posts: n/a

Default Perl DBI and Various Codepages - 08-18-2003 , 10:48 AM






I'm accessing a db2/400 system via Perl DBI and the DBD:B2 module, but
when I go to pull data out of any table that's not codepage 37 I get an
error that looks like this:

"BD:B2::st execute failed: [IBM][CLI Driver][AS] SQL0332N There is no
available conversion for the source code page "937" to the target code page
"1252". Reason Code "1". SQLSTATE=57017"

I understand why this is happening, but not how to remedy the situation. I
cannot change the codepage for the tables because they are storing
multilingual data. Can anyone give me any advice on how I can work around
this problem?



Reply With Quote
  #2  
Old   
Sherman Lau
 
Posts: n/a

Default Re: Perl DBI and Various Codepages - 08-18-2003 , 12:39 PM






DB2 does not support connection between different language groups. 1252 is
Latin 1 and 937 is Traditional Chinese.

Can you change your client to Unicode? A Unicode client can connect to any
databases.

Sherman

"Dana Cordes" <dcordes (AT) nhbb (DOT) com> wrote

Quote:
I'm accessing a db2/400 system via Perl DBI and the DBD:B2 module, but
when I go to pull data out of any table that's not codepage 37 I get an
error that looks like this:

"BD:B2::st execute failed: [IBM][CLI Driver][AS] SQL0332N There is no
available conversion for the source code page "937" to the target code
page
"1252". Reason Code "1". SQLSTATE=57017"

I understand why this is happening, but not how to remedy the situation.
I
cannot change the codepage for the tables because they are storing
multilingual data. Can anyone give me any advice on how I can work around
this problem?





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.