using 8 bit ascii - Mailing list pgsql-jdbc

From Jason Tesser
Subject using 8 bit ascii
Date
Msg-id 04875CB4331F0240A0AD66F9709786510272AC98@paul
Whole thread Raw
Responses Re: using 8 bit ascii
Re: using 8 bit ascii
List pgsql-jdbc
I have a Postgres database (version 7.4.2) that is using acsii character
233 which is an 8
bit ascii character. I also use jboss.  My problem is when I try to
retrieve
a resultset that has a record with one of the 8bit ascii characters I
get a
message from jboss (see error message below.

My question is there a way to configure the postgres jdbc driver to
allow
for this range of characters?

2004-10-26 16:54:51,167 ERROR [STDERR]
org.postgresql.util.PSQLException: Invalid character data was found.
This is most likely caused by stored data containing characters that are
invalid for the character set the database was created in.  The most
common example of this is storing 8bit data in a SQL_ASCII database.
2004-10-26 16:54:51,167 ERROR [STDERR]  at
org.postgresql.core.Encoding.decodeUTF8(Encoding.java:287)
2004-10-26 16:54:51,167 ERROR [STDERR]  at
org.postgresql.core.Encoding.decode(Encoding.java:182)
2004-10-26 16:54:51,167 ERROR [STDERR]  at
org.postgresql.core.Encoding.decode(Encoding.java:198)
2004-10-26 16:54:51,167 ERROR [STDERR]  at
org.postgresql.jdbc1.AbstractJdbc1ResultSet.getString(AbstractJdbc1Resul
tSet.java:201)
2004-10-26 16:54:51,167 ERROR [STDERR]  at
org.postgresql.jdbc1.AbstractJdbc1ResultSet.getString(AbstractJdbc1Resul
tSet.java:475)
2004-10-26 16:54:51,168 ERROR [STDERR]  at
payroll.DeptWorkers.loadWorkers(DeptWorkers.java:52)
2004-10-26 16:54:51,168 ERROR [STDERR]  at
org.apache.jsp.manager_jsp._jspService(manager_jsp.jav


pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: Problems with protocol V3 after migration to latest driver
Next
From: Anders Hermansen
Date:
Subject: Re: using 8 bit ascii