Re: JDBC and CCSID problem

["Franco Biaggi" <fbiaggi@xxxxxxxxxx>]

Hi,
look at the QLANGID sysval,
this may cause the error.
If you cannot change it, change the usrpfr that connect over JDBC.

Hope this helps.

On Fri, 27 Feb 2004 10:37:45 +0100, Balazs Vojtek wrote:

>Hello there,

>I have some problems regarding character conversion into the right CCSID 
>when running JDBC insert statements. In my program I'm using 2 database 
>connections 1 to our enterprise AS400 database and one to a small Firebird 
>database. I'm trying to read the data from Firebird, then making some 
>conversions and calculations, then to insert the result into DB2 database 
>file. 
>I have tested the program and configuration on my PC and it worked without 
>problem, the special characters had been written correctly. As 
>soon as I have tried to run the program on the iSeries, (some of)  the 
>special characters weren't written correctly. I have tried to debug the 
>program and found that the program interprets the  red data incorrectly. I 
>was trying to use some conversion before writing the data but I was unable 
>to specify the CCSID of the interpretation of input data .
>Our machine runs on V5R1, and the CCSID of the database is 870.
>The Firebird database runs on WinXP with windows-1250 encoding.

>Thank you for your help

>Best regards

>Balazs
>_______________________________________________
>This is the Java Programming on and around the iSeries / AS400 (JAVA400-L) 
>mailing list
>To post a message email: JAVA400-L@xxxxxxxxxxxx
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/mailman/listinfo/java400-l
>or email: JAVA400-L-request@xxxxxxxxxxxx
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/java400-l.



-----------------------------------------------------------------------------
*** This messages was scanned for malicious contents ***
-----------------------------------------------------------------------------
Franco Biaggi
CH-6807 Taverne