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