Re: using 8 bit ascii - Mailing list pgsql-jdbc

From Jason Tesser
Subject Re: using 8 bit ascii
Date
Msg-id 04875CB4331F0240A0AD66F97097865101137ADD@paul
Whole thread Raw
In response to using 8 bit ascii  ("Jason Tesser" <JTesser@nbbc.edu>)
Responses Re: using 8 bit ascii
List pgsql-jdbc
OK I tried the Unicode but the data won't come in as it says it cannot support the Unicode values I am inserting.  I
triedconverting the data as a text file and everything.  Nothing has worked there.  With odbc using access for example
Ican pull the 8 bit characters out just fine from the same database.  So why can I not using postgres jdbc? 
I understand that ascii is 7 bit but these are extended ascii.  I will try Latin 1

> -----Original Message-----
> From: pgsql-jdbc-owner@postgresql.org [mailto:pgsql-jdbc-
> owner@postgresql.org] On Behalf Of Anders Hermansen
> Sent: Wednesday, October 27, 2004 8:12 AM
> To: pgsql-jdbc@postgresql.org
> Subject: Re: [JDBC] using 8 bit ascii
>
> 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@nbbc.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
> >
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly



pgsql-jdbc by date:

Previous
From: Anders Hermansen
Date:
Subject: Re: using 8 bit ascii
Next
From: Anders Hermansen
Date:
Subject: Re: using 8 bit ascii