Re: Problem with postgres and Suse - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: Problem with postgres and Suse
Date
Msg-id Pine.BSO.4.56.0409140537510.18601@leary.csoft.net
Whole thread Raw
In response to Problem with postgres and Suse  (Albert Vilà <albvil@gmail.com>)
List pgsql-jdbc

On Tue, 14 Sep 2004, [ISO-8859-1] Albert Vilà wrote:

> With build 215 and Debian all it's ok
>
> Now with suse and 215 the problem is :
>
> java.lang.Exception: 0 -  - 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.

Yes, but this is different stacktrace than you initially showed.  The
error message seems clear.  What is the encoding of your database?  It
appears not to be set correctly for your data.  The JDBC driver (unlike
most other client interfaces) requires your data to be encoded correctly.
Unfortunately the only way to fix it is a dump and reload.

Kris Jurka


pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: Problem with postgres and Suse
Next
From: Tim Penhey
Date:
Subject: Problem with dollar-quoted CREATE OR REPLACE FUNCTION