Received: from localhost (maia-2.hub.org [200.46.204.187])
	by postgresql.org (Postfix) with ESMTP id 5A2C09FB7D0
	for <pgsql-jdbc-postgresql.org@postgresql.org>;
	Tue, 20 Feb 2007 07:04:03 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024)
	with ESMTP id 96406-06 for <pgsql-jdbc-postgresql.org@postgresql.org>;
	Tue, 20 Feb 2007 07:03:45 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from web39108.mail.mud.yahoo.com (web39108.mail.mud.yahoo.com
	[209.191.87.227])
	by postgresql.org (Postfix) with SMTP id 79A789FB7E0
	for <pgsql-jdbc@postgresql.org>; Tue, 20 Feb 2007 07:03:49 -0400 (AST)
Received: (qmail 12749 invoked by uid 60001); 20 Feb 2007 10:57:07 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=X-YMail-OSG:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID;
	b=vcziLXxsxxI49AKZFt/MvHB9Z2kjIUlUvrBODnQhDpsbGN+gyuOjpRGyrAagBqFxvjNVOd3Sa7vhTmiWjG9DK95M9R60yok4GX9zm9Lqpy6d1Jj1aSP8sNKfz1cjFd7JCsOtQjARsYkDSQHRzC7s5qgxmCrfl3UEM0c3LgHcI8o=;
X-YMail-OSG: 
 g2VW1WcVM1kqKzN1b_lt0u26G.4N8U7EC4QWiOg1h4eOozCWE0HfXBS9RkINt6Y1wW.FMJL_ilB1NbcvTTW8hyEli.t4BNnGCzHBYFjkoXQVwC2YAtDHiFPyiFvXIVizvyyuzeAV2HTntcM-
Received: from [203.215.160.146] by web39108.mail.mud.yahoo.com via HTTP;
	Tue, 20 Feb 2007 02:57:07 PST
Date: Tue, 20 Feb 2007 02:57:07 -0800 (PST)
From: Altaf Malik <mmalik_altaf@yahoo.com>
Subject: Re: invalid byte sequence for encoding "UTF8": 0x00
To: James Im <im-james@hotmail.com>, pgsql-jdbc@postgresql.org
In-Reply-To: <BAY7-F17FFE0E324AB3B642C547E96890@phx.gbl>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1489091908-1171969027=:12351"
Content-Transfer-Encoding: 8bit
Message-ID: <793207.12351.qm@web39108.mail.mud.yahoo.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200702/106
X-Sequence-Number: 16662

--0-1489091908-1171969027=:12351
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Try to change the encoding of your database to "Unicode". 
  I hope this helps.
   
  --Altaf Malik
  EnterpriseDB
  www.enterprisedb.com
  
James Im <im-james@hotmail.com> wrote:
  Hi,

I've got another problem. I sometimes get the following SQLException
when doing an insert:

ERROR: invalid byte sequence for encoding "UTF8": 0x00
Exception: org.postgresql.util.PSQLException
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:308)

By the way, the insert is done with a PreparedStatement and I use only
setLong(), setString(), setTimestamp() and setInt().


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.

Any idea?

_________________________________________________________________
Opret en personlig blog og del dine billeder på MSN Spaces: 
http://spaces.msn.com/


---------------------------(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


 
---------------------------------
Don't get soaked.  Take a quick peak at the forecast 
 with theYahoo! Search weather shortcut.
--0-1489091908-1171969027=:12351
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

<div>Try to change the encoding of your database to "Unicode". </div>  <div>I hope this helps.</div>  <div>&nbsp;</div>  <div>--Altaf Malik</div>  <div>EnterpriseDB</div>  <div><A href="http://www.enterprisedb.com">www.enterprisedb.com</A></div>  <div><BR><B><I>James Im &lt;im-james@hotmail.com&gt;</I></B> wrote:</div>  <BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">Hi,<BR><BR>I've got another problem. I sometimes get the following SQLException<BR>when doing an insert:<BR><BR>ERROR: invalid byte sequence for encoding "UTF8": 0x00<BR>Exception:
 org.postgresql.util.PSQLException<BR>org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)<BR>org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)<BR>org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)<BR>org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)<BR>org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)<BR>org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:308)<BR><BR>By the way, the insert is done with a PreparedStatement and I use only<BR>setLong(), setString(), setTimestamp() and setInt().<BR><BR><BR>I don't understand it very well. It is obviously an encoding exception<BR>but I don't know why it happens and what I could do avoid it.<BR><BR>Any idea?<BR><BR>_________________________________________________________________<BR>Opret en personlig blog og del dine
 billeder på MSN Spaces: <BR>http://spaces.msn.com/<BR><BR><BR>---------------------------(end of broadcast)---------------------------<BR>TIP 1: if posting/reading through Usenet, please send an appropriate<BR>subscribe-nomail command to majordomo@postgresql.org so that your<BR>message can get through to the mailing list cleanly<BR></BLOCKQUOTE><BR><p>&#32;

<hr size=1>
Don't get soaked.  Take a<a href="
http://tools.search.yahoo.com/shortcuts/?fr=oni_on_mail&#news"> quick peak at the forecast </a><br> with the<a href="
http://tools.search.yahoo.com/shortcuts/?fr=oni_on_mail&#news">Yahoo! Search weather shortcut.</a>
--0-1489091908-1171969027=:12351--