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