[BUG] - Invalid UNICODE character sequence found (0xc000)

From: "Antonio Gallardo" <antonio(at)apache(dot)org>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: [BUG] - Invalid UNICODE character sequence found (0xc000)
Date: 2004-01-09 05:18:39
Message-ID: 34155.10.0.0.5.1073625519.squirrel@ags01.agsoftware.dnsalias.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi:

First, here is the postgreSQL version used:
PostgreSQL 7.3.4-RH on i386-redhat-linux-gnu, compiled by GCC
i386-redhat-linux-gcc (GCC) 3.3.2 20031022 (Red Hat Linux 3.3.2-1)

I am aware similar problem was already sent to this list (I read some of
them), but I want to contribute with more interesting stuff:

In the tested web application, we use postgreSQL JDBC driver. We have a 1
field form where we allow the user to writte a search pattern a table. The
generated SQL use LIKE to find for similars. Example:

If the user write: "ant" then the answer will be:

antonio
antoine
etc.

This works fine, even if we left empty the form field, to show all the
records.

The interesting stuff I found is:

If we write just "z", "Z" or any string with that include the chars "z" or
"Z" at any point of the string in the field, then I got the below error.
How is this posible? I not an UTF-8, ISO-8859-1 or SQL_ASCII expert, but
for me "z" or "Z" is part of the ASCII that means a 1 byte code in UTF-8.

That means the driver has problems with an normal "z" or "Z"?

Note: The same apply for the drivers:

pg73jdbc.jar
pg74jdbc.jar
pg74.1jdbc.jar

Please explain.

Best Regards,

Antonio Gallardo

Caused by: java.sql.SQLException: ERROR: Invalid UNICODE character
sequence found (0xc000)

at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131)
at
org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection.java:505)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:320)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:48)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:153)

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Xavier Bugaud 2004-01-09 06:28:43 Nmber of rows in a ResultSet
Previous Message Jonathan Purvis 2004-01-09 03:01:34 JDBC driver doesn't handle NaN values