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