Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group