Re: using 8 bit ascii

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 tried converting the data as a text file and everything. Nothing has worked there. With odbc using access for example I can 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(at)postgresql(dot)org [mailto:pgsql-jdbc-
> owner(at)postgresql(dot)org] On Behalf Of Anders Hermansen
> Sent: Wednesday, October 27, 2004 8:12 AM
> To: pgsql-jdbc(at)postgresql(dot)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(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
> >
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly