Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group