Subject: Re: invalid byte sequence for encoding "UTF8": 0x00
From: Csaba Nagy <nagy@ecircle-ag.com>
To: Altaf Malik <mmalik_altaf@yahoo.com>
Cc: James Im <im-james@hotmail.com>, Postgres JDBC <pgsql-jdbc@postgresql.org>
In-Reply-To: <793207.12351.qm@web39108.mail.mud.yahoo.com>
References: <793207.12351.qm@web39108.mail.mud.yahoo.com>
Content-Type: text/plain; charset=UTF-8
Message-Id: <1171970019.3101.328.camel@coppola.muc.ecircle.de>
Mime-Version: 1.0
Date: Tue, 20 Feb 2007 12:13:39 +0100
Content-Transfer-Encoding: quoted-printable

I've had the same error, and it is in fact because in Java you can
actually have a "0x0" character in your string, and that's valid
unicode. So that's translated to the character 0x0 in UTF8, which in
turn is not accepted because the server uses null terminated strings...
so the only way is to make sure your strings don't contain the character
'\u0000'.

I identified the place in my code which was generating such a character
and fixed, and I didn't have other problems after that... even if I
still think forbidding a valid character is a somewhat arbitrary
restriction.

HTH,
Csaba.

On Tue, 2007-02-20 at 11:57, Altaf Malik wrote:
> Try to change the encoding of your database to "Unicode".=20
> I hope this helps.
> =20
> --Altaf Malik
> EnterpriseDB
> www.enterprisedb.com
> James Im <im-james@hotmail.com> wrote:
>         Hi,
>        =20
>         I've got another problem. I sometimes get the following
>         SQLException
>         when doing an insert:
>        =20
>         ERROR: invalid byte sequence for encoding "UTF8": 0x00
>         Exception: org.postgresql.util.PSQLException
>         org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(Que=
ryExecutorImpl.java:1525)
>         org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExec=
utorImpl.java:1309)
>         org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImp=
l.java:188)
>         org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2=
Statement.java:452)
>         org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abst=
ractJdbc2Statement.java:354)
>         org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(Abstrac=
tJdbc2Statement.java:308)
>        =20
>         By the way, the insert is done with a PreparedStatement and I
>         use only
>         setLong(), setString(), setTimestamp() and setInt().
>        =20
>        =20
>         I don't understand it very well. It is obviously an encoding
>         exception
>         but I don't know why it happens and what I could do avoid it.
>        =20
>         Any idea?
>        =20
>         _________________________________________________________________
>         Opret en personlig blog og del dine billeder p=C3=A5 MSN Spaces:=20
>         http://spaces.msn.com/
>        =20
>        =20
>         ---------------------------(end of
>         broadcast)---------------------------
>         TIP 1: if posting/reading through Usenet, please send an
>         appropriate
>         subscribe-nomail command to majordomo@postgresql.org so that
>         your
>         message can get through to the mailing list cleanly
>=20
>=20
> ______________________________________________________________________
> Don't get soaked. Take aquick peak at the forecast=20
> with theYahoo! Search weather shortcut.