7 messages in org.postgresql.pgsql-jdbcRe: invalid byte sequence for encodin...| From | Sent On | Attachments |
|---|---|---|
| James Im | Feb 20, 2007 2:48 am | |
| Altaf Malik | Feb 20, 2007 2:56 am | |
| Csaba Nagy | Feb 20, 2007 3:13 am | |
| Oliver Jowett | Feb 20, 2007 3:49 am | |
| Ken Johanson | Feb 21, 2007 10:37 pm | |
| Oliver Jowett | Feb 22, 2007 12:53 am | |
| Tore Halset | Feb 23, 2007 9:31 am |
| Subject: | Re: invalid byte sequence for encoding "UTF8": 0x00 | |
|---|---|---|
| From: | Altaf Malik (mmal...@yahoo.com) | |
| Date: | Feb 20, 2007 2:56:44 am | |
| List: | org.postgresql.pgsql-jdbc | |
Try to change the encoding of your database to "Unicode". I hope this helps.
--Altaf Malik EnterpriseDB www.enterprisedb.com
James Im <im-j...@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 majo...@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.