Re: using 8 bit ascii

From: Anders Hermansen <anders(at)yoyo(dot)no>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: using 8 bit ascii
Date: 2004-10-27 13:11:40
Message-ID: 20041027131140.GB7634@online.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hello Jason,

ASCII is only 7-bit. Values 0 to 127.

ISO-8859-1 is an example of a character set with 8-bits (0 to 255).
233 is é in ISO-8859-1 (Latin-1).

You should create the database with an encoding which can handle 8-bit
characters. I.e. ISO-8859-1 (Postgresql: Latin-1) or UTF-8 (Postgresql:
UNICODE)

Anders

* Jason Tesser (JTesser(at)nbbc(dot)edu) wrote:
> 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
>

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Jason Tesser 2004-10-27 13:23:29 Re: using 8 bit ascii
Previous Message Jason Tesser 2004-10-27 12:55:18 using 8 bit ascii