Re: Strange error using postgres 8.2 + JDBC 8.2 driver

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