Re: DBCS to Unicode

Just for additional info,
the conversion is done also using the QLANGID system value.

Just my cent.

On Mon, 15 Dec 2003 13:36:11 -0500, Joe Sam Shirah wrote:


>    Hi Anwar,

>    My answer is tempered somewhat by the age of your releases, but should
>be generally correct and the expected behavior.

>    So long as the database accepts the CCSID for the data, the DBCS in your
>case, the database and JDBC driver should convert as normal.  That is, from
>the native CCSID to Unicode internally in the Java program and back to the
>native CCSID on output..

>    The data in a Data Queue should be in the default system CCSID, and
>again, converted by the Toolbox/JTOpen classes on input and output.

>    All of that assumes that no one tried to get cute and put data in one
>character set or CCSID into a database with a different CCSID without proper
>conversion.

>    The JTOpen/Toolbox people have been pretty careful about backward
>compatibility and you can probably move to a later version to avoid possible
>bugs.

>    For more information, look under National Language Support ( NLS ) in
>the AS/400 documentation.  There are also several redbooks dealing with
>i18n development.  HTH,


>                                                         Joe Sam

>Joe Sam Shirah -        http://www.conceptgo.com
>conceptGO         -        Consulting/Development/Outsourcing
>Java Filter Forum:       http://www.ibm.com/developerworks/java/
>Just the JDBC FAQs: http://www.jguru.com/faq/JDBC
>Going International?    http://www.jguru.com/faq/I18N
>Que Java400?             http://www.jguru.com/faq/Java400



>----- Original Message -----
>From: "Mahmood, Anwar (Cognizant)" <MANWAR@xxxxxxxxxxxxxxxxx>
>To: <java400-l@xxxxxxxxxxxx>
>Sent: Tuesday, December 09, 2003 5:11 AM
>Subject: DBCS to Unicode


>> hi all,
>> I need to get data from a DB2 database (on a V4R1 system). It is a
>japaneses system and DBCS enabled. Can some one tell me that if i use
>JT400Mod0 to fetch data using jdbc or DataQ, what is the character set in
>which i will get it? and how do i convert it to Unicode?
>> Any help will be apreciated...
>>
>> regards,
>> Anwar
>>




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