Re: Inserting Data into Database with Japanesecharacters

From: David Gibbs <david@xxxxxxxxxxxx>
Subject: Re: Inserting Data into Database with Japanesecharacters
To: "Java Programming on and around the iSeries / AS400" <java400-l@xxxxxxxxxxxx>
Date: Tuesday, October 28, 2008, 1:53 PM
Ashish Kulkarni wrote:

I am trying to insert data in a table with CCSID 5026

(Japanese)

using JDBC and SQL, i get the data in XML file which

is defined in

UTF-8, so when i open the XML file in Browser i can

see proper

Japanese characters but when i insert this data in

table, i get

garbage. Is there some thing i need to set in JDBC

connection

parameter or convert string before inserting. I am

using prepared

statement to insert data.

Does the user profile you are using to make the jdbc
connection with have the correct CCSID?

I'm assuming the field you are trying to put data into
is double byte enabled.

david


--
IBM i on Power - For when you can't afford to be out of
business
--
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.