Convert Binary Code

My team and working with AS400 data and we need to know how to convert binary data (CCSID 65535) becuase we aren't getting this data when we try to query. We get the following error:


BINARY data can't be displayed.


Dylan Wan Dan Brock Ari Gnanam

5replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Specifically being able to bring in an CHAR () FOR BIT DATA column.

    • joseph. delpercio The AS400 DB2 driver you're using isn't a productized driver so we don't have a lot of experience with it.  Does it support CAST() to have the DB2 database convert the datatype in your SELECT statement?

      Like 1
  • Hey Dan, we were able to figure it out with adding additional details into the connection string

    Like 1
    • joseph. delpercio Great!  Can you post what those additional details were so we can refer others to this thread down the road?

  • You bet: Connection Properties: jdbc:as400://"Server or IP"/"DB";translate binary=true

Like Follow
  • Status Answered
  • 1 yr agoLast active
  • 5Replies
  • 22Views
  • 2 Following

Product Announcement

A new community experience is coming! If you would like to have beta access to provide feedback, please contact us at community@incorta.com.