How to translate CCSID 65535 in SQuirrel from a DB2 on an iseries
Posted
by
ZS6JCE
on Stack Overflow
See other posts from Stack Overflow
or by ZS6JCE
Published on 2011-11-24T13:21:14Z
Indexed on
2011/11/24
17:50 UTC
Read the original article
Hit count: 671
I am new to SQuirrel SQL. I need some help to translating CCSID 65535 into ASCII, UNICODE (or anything human readable)
I am using the JDBC driver per the following guide.
According to IBM's website:
What character conversion issues must my program deal with? The IBM i database uses EBCDIC to store text. Java uses Unicode. The JDBC driver handles all conversion between character sets, so your program should not have to worry about it.
but I think they refer to CCSID 37 and not 65535(Hex).
I have got the following info, from my DB2 DB
Doing DSPFD gives me:
Coded character set identifier . . . . . . : CCSID 65535
Doing DSPFFD gives me:
TXT CHAR 3 3 41 Both Text
Field text . . . . . . . . . . . . . . . : Text Coded Character
Set Identifier . . . . . : 65535
But the SQuirrel query result for the TXT field is:
5c c1 c4 c4 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 c1 40 7e 40 c2 40 4e 40 c3 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40
Which should be translated to something like:
*ADD A = B + C
© Stack Overflow or respective owner