Quoting Joel Seguillon <seguij(at)free(dot)fr>:
> I'm trying to use JDBC driver for postgres but have a problem with
> I can insert UNICODE values but I can't compare them unless they are
> When I try to compare values that are over 00ff always return true :
> // inserting a Unicode value in the database
> smt.executeUpdate("insert into test values ('\u0123')");
> // not the same unicode value selects the same line !!!
> smt.executeQuery("select * from test where test = '\u0223'");
> (but '\u0064' and '\0034' are not the same :))
As executeQuery & executeUpdate pass the query to the backend without any
modifications (well a few occasionally but not in this case), this looks like a
backend type of problem.
Forwarding to the hackers list.
> I compiled the postgres.jar with the jdbc2 and the 7.0.3 version,
> postgresql with --enable-multibyte and created my database with -E
> I also use the Properties class to connect to my base to specifie that i
> to use Utf-8.
The key is "charSet" case sensitive...
Peter Mount peter(at)retep(dot)org(dot)uk
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/
In response to
- at 2001-04-02 16:30:31 from Joel Seguillon
pgsql-jdbc by date
|Next:||From: Gabriel García||Date: 2001-04-03 15:54:54|
|Subject: Help for java|
|Previous:||From: Joel Seguillon||Date: 2001-04-02 16:30:31|