Re: Determine if a String will result in a double byte value in DB2/400?

Hi David,

Not sure I completely understand, and you may (possibly, don't have the time to double[unintended pun] check) get snagged by some non-US EBCDIC variant where Unicode is double byte but the code set isn't. But...

You should be able to take the Unicode string character by character and put it into a char variable, which is 16 bits. Check the numeric value of the char. If GT 127, then it's a double byte.

Does that help or did I completely miss your problem?

I also wonder how helpful persisting only half a string will be. You do know that the AS/400 now supports UTF-8, right? Of course, that may not be an option; don't know your app. 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: "David Gibbs" <david@xxxxxxxxxxxx>
To: "Java Programming on and around the iSeries / AS400" <java400-l@xxxxxxxxxxxx>
Sent: Tuesday, June 24, 2008 2:50 PM
Subject: Determine if a String will result in a double byte value in DB2/400?

Folks:

Does anyone know if there is a way, using JT400, to determine if the
value of a String will result in double byte data once stored in a
DB2/400 database column (assuming an appropriate CCSID, like 5026)?

I've got a situation where I could be handed variable length unicode
data in a String variable ... and I need to store the value in a fixed
length DB2 database field. Problem is, I need to trim the data to the
appropriate length before setting the value in the sql statement so it
doesn't overflow the field.

Thanks!

david

--
IBM System i - 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.