Hello
I have got data in DB2 V 9.1 under ZOS. When I select data from Table, I can not see right Character in my application program. By this program I could see easily in DB2 V 7.1 . Instead of right character I see Byte[] Array or Hex string (by two mode BITDATA of DB2 Connect).

Please Help Me.

the API detects for bit data, and show its hex value. By book, this is correct behavior.


I think there was a bug for V7, which show the string directly.

nidm is correct. If you have binary data (VARCHAR FOR BIT DATA or BLOB), then it is a really bad idea if a client would try to interpret the data as string - unless it really knows that the data has only code points in the current code page, which the DB2 client cannot assume.