Re: invalid byte sequence for encoding "UTF8": 0x00

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: James Im <im-james(at)hotmail(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: invalid byte sequence for encoding "UTF8": 0x00
Date: 2007-02-20 11:50:14
Message-ID: 45DAE076.1060407@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-jdbc

James Im wrote:

> I've got another problem. I sometimes get the following SQLException
> when doing an insert:
>
> ERROR: invalid byte sequence for encoding "UTF8": 0x00

You're trying to insert a string which contains a '\0' character. The
server can't handle strings containing embedded NULs, as it uses C-style
string termination internally.

-O

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Eamonn Kent 2007-02-20 18:14:13 Max files per process..
Previous Message Csaba Nagy 2007-02-20 11:13:39 Re: invalid byte sequence for encoding "UTF8": 0x00

Browse pgsql-jdbc by date

  From Date Subject
Next Message Scott Marlowe 2007-02-20 15:39:41 Re: how to continue using a connection after an error with autocommit=false
Previous Message Csaba Nagy 2007-02-20 11:13:39 Re: invalid byte sequence for encoding "UTF8": 0x00