Thread: JDBC encoding

JDBC encoding

From
Lxir
Date:
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 ?

Thanks,

    Lxir

Re: JDBC encoding

From
Kris Jurka
Date:

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