Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2007
    Location
    Tehran
    Posts
    2

    Unanswered: Have data in varchar FOR BIT DATA

    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.
    Last edited by reza_tak2003; 01-31-08 at 11:57.

  2. #2
    Join Date
    May 2003
    Posts
    113
    Quote Originally Posted by reza_tak2003
    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.

  3. #3
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    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.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •