Re: JDBC encoding

From: Kris Jurka <books(at)ejurka(dot)com>
To: Lxir <lxir(at)sepao(dot)net>
Cc: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: JDBC encoding
Date: 2003-12-09 21:11:14
Message-ID: Pine.LNX.4.33.0312091610360.3369-100000@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2003-12-09 21:16:13 Re: How to kill a connection
Previous Message Bob Rivers 2003-12-09 17:28:04 How to kill a connection