Re: JDBC encoding - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: JDBC encoding
Date
Msg-id Pine.LNX.4.33.0312091610360.3369-100000@leary.csoft.net
Whole thread Raw
In response to JDBC encoding  (Lxir <lxir@sepao.net>)
List pgsql-jdbc

On Wed, 3 Dec 2003, Lxir wrote:

> Hi !
>
> I've searched and read in your archives hopping to find a solution but I
> haven't... so here is my problem:
>
> I've a 7.3.3 postgres database and a 1.4.2 JVM so I use pg73jdbc3 driver,
> which I call through "jdbc:postgresql:mydb?charSet=ISO_8859_1". But I've got
> the famous error:
>
> "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."
>
> Do I have to reinit by postgres with -E LATIN1 or is there another solution ?
>

This is the only solution.

Kris Jurka



pgsql-jdbc by date:

Previous
From: Lxir
Date:
Subject: JDBC encoding
Next
From: Kris Jurka
Date:
Subject: Re: How to kill a connection