View Single Post

   
  #2 (permalink)  
Old 04-16-2008, 01:31 AM
Kris Jurka
 
Posts: n/a
Default 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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Reply With Quote