Re: JDBC does not know CCSID=65535?

["Bruce Jin" <brucej@xxxxxxxxxxxxxxxxxxxx>]

Thanks Richard;

Now everything is displayed correctly after I added Property  "translate
binary=true".

Bruce

-----Original Message-----
From: Richard Dettinger <cujo@us.ibm.com>
To: JAVA400-L@midrange.com <JAVA400-L@midrange.com>
Date: Friday, April 06, 2001 3:03 PM
Subject: 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
>+---

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