From: | "Dave Cramer" <Dave(at)micro-automation(dot)net> |
---|---|
To: | "Joel SEGUILLON" <Joel(dot)Seguillon(at)Uhb(dot)Fr>, "PostgreSQL jdbc list" <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: Unicode problems. |
Date: | 2001-05-23 11:32:22 |
Message-ID: | 027001c0e37c$08e4b4f0$0401a8c0@INSPIRON |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Joel,
What happens when you do the select in psql ?
Dave
----- Original Message -----
From: "Joel SEGUILLON" <Joel(dot)Seguillon(at)Uhb(dot)Fr>
To: "PostgreSQL jdbc list" <pgsql-jdbc(at)postgresql(dot)org>
Sent: Wednesday, May 23, 2001 7:05 AM
Subject: [JDBC] Unicode problems.
> Hi all,
> I'm trying to use the jdbc driver for postgresql to insert unicode
> values in my database.
>
> I've got a table : test(test_field varchar(50)).
> I'm trying to insert and compare unicode string in this test_field,
> but if I insert two different values ("\u2293", "\u2256") with a
> PreparedStatement and a setString, the backend does not seem to make a
> difference beetween those two values. If I try a Select from test where
> test_field = ? and a setString(1, "\u2256") my result set gives me two
> lines.
>
> Could someone please help me ?
>
> I compiled postgres with blcksz=32768 and the
> --enable-multibyte=UNICODE option. \encoding returns me UNICODE
> I connect to the server whith jdbc7.0_1.2 (found at
> jdbc.postgresql.org)
> I use the property charSet=utf-8 when making the connection
> (info.put("charSet", "utf-8"); Driver.getConnection(db, info);)
>
> Thanks.
>
> Joel Seguillon.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
From | Date | Subject | |
---|---|---|---|
Next Message | Joel SEGUILLON | 2001-05-23 12:29:47 | Re: Unicode problems. |
Previous Message | Joel SEGUILLON | 2001-05-23 11:05:33 | Unicode problems. |