Re: db2 database returns ebcdic

From: Arne Vajhøj <arne@xxxxxxxxxx>
Date: Thu, 14 Sep 2006 19:05:06 -0400

John Smith wrote:

I am running a PreparedStatement query against a DB2 database on a mainframe and it is returning EBCDIC strings to me. How can I get the query to return ASCII strings?

If

rs.getString(colix)

does not work even though it should then try

new String(rs.getBytes(colix), "Cp1047")

or

new String(rs.getBytes(colix), "Cp037")

Arne
.

References:
- db2 database returns ebcdic
  - From: John Smith

Prev by Date: Re: db2 database returns ebcdic
Next by Date: Re: OJB and inheritance
Previous by thread: Re: db2 database returns ebcdic
Index(es):
- Date
- Thread