Re: Strange error using postgres 8.2 + JDBC 8.2 driver

From: Kris Jurka <books(at)ejurka(dot)com>
To: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
Cc: Postgres JDBC <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Strange error using postgres 8.2 + JDBC 8.2 driver
Date: 2007-01-17 17:07:35
Message-ID: Pine.BSO.4.64.0701171202470.29608@leary2.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Wed, 17 Jan 2007, Csaba Nagy wrote:

> I get the following error:
>
> org.postgresql.util.PSQLException: ERROR: invalid byte sequence for
> encoding "UTF8": 0x00
> at
>
> Any ideas how could I further debug this ? It's show-stopper for us in
> adopting 8.2.
>

This will actually happen in 8.1 servers if you are running the latest
releases. Previously, inserting something like "a\0b" would silently
truncate at the null byte, but now it's an error. So, check your data for
\0.

Kris Jurka

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Csaba Nagy 2007-01-17 17:13:53 Re: Strange error using postgres 8.2 + JDBC 8.2 driver
Previous Message Csaba Nagy 2007-01-17 16:58:37 Strange error using postgres 8.2 + JDBC 8.2 driver