using 8 bit ascii

From: "Jason Tesser" <JTesser(at)nbbc(dot)edu>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: using 8 bit ascii
Date: 2004-10-27 12:55:18
Message-ID: 04875CB4331F0240A0AD66F9709786510272AC98@paul
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Anders Hermansen 2004-10-27 13:11:40 Re: using 8 bit ascii
Previous Message Kris Jurka 2004-10-26 17:33:23 Re: Problems with protocol V3 after migration to latest driver