RE: JDBC does not know CCSID=65535?

Property is "translate binary=true"

As in the URL
     "jdbc:db2:localhost;translate binary=true"

or you could put it in the connection properties object that gets passed on
the connect methods.

BTW:  Its is a feature.  ;-)  Without some way to represent binary data you
would not be able to serial java objects and put them into the database
without data translation happening to them.  Also, you could not optimize
out data translation by putting raw UTF-8 data in the database.

I know... its a little annoying, but its a necessary evil (for now anyway).
I would like to see the keyword binary and varbinary available on the
system (and have it used as a real data type - not just a mask over the top
of CHAR FOR BIT DATA.  Maybe someday, but probably not someday soon.

Regards,

Richard D. Dettinger
AS/400 Java Data Access Team

"Biologists have a special word for stability -- dead"

                Larry Wall
                Open Source Developers Journal
                Issue 1, Jan  2000


"Clapham, Paul" <pclapham@core-mark.com>@midrange.com on 04/06/2001
01:17:36 PM

Please respond to JAVA400-L@midrange.com

Sent by:  owner-java400-l@midrange.com


To:   JAVA400-L@midrange.com
cc:
Subject:  RE: JDBC does not know CCSID=65535?



Files with CCSID of 65535 are created when you do CRTPF ... RCDLEN(xxx).
According to IBM, these files are interpreted as if they contain
hexadecimal
data, or something like that.  They seem to feel that this is a feature and
not a bug.  At least with Client Access there's a checkbox in the
Properties
of the download object where you can turn off this "feature".  There may be
a JDBC connection property you can specify to do that too, but I can't find
where I put that list.  It's available somewhere online, maybe somebody can
point you to it.

PC2

-----Original Message-----
From: Bruce Jin [mailto:brucej@MRC-PRODUCTIVITY.COM]
Sent: April 6, 2001 10:09
To: JAVA400-L@midrange.com
Subject: JDBC does not know CCSID=65535?


When I use jdbc on PC to query files on as400, the alpha fields are all
messed up if the file has a ccsid=65535. Files with ccsid=37 are displayed
ok. Why?

I confess I don't know why some of my files have ccsid=65535 and some have
ccsid=37.

Thanks.
Bruce


+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---
+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---



+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---