From: Joel Seguillon <seguij(at)free(dot)fr>
To: pgsql-jdbc(at)postgresql(dot)org
Subject:
Date: 2001-04-02 16:30:31
Message-ID: 986229031.3ac8a9273f67b@imp.free.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi,
I'm trying to use JDBC driver for postgres but have a problem with UNICODE.
I can insert UNICODE values but I can't compare them unless they are under
00ff...

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

I compiled the postgres.jar with the jdbc2 and the 7.0.3 version, compiled
postgresql with --enable-multibyte and created my database with -E UNICODE.

I also use the Properties class to connect to my base to specifie that i wan't
to use Utf-8.

If you can help me .... thanks.

Responses

  • Re: at 2001-04-03 13:17:18 from Peter T Mount

Browse pgsql-jdbc by date

  From Date Subject
Next Message Peter T Mount 2001-04-03 13:17:18 Re:
Previous Message Peter T Mount 2001-04-02 14:03:49 Re: RE: Problem connecting to JDBC 7.0-1.2 driver