From: | Joel SEGUILLON <Joel(dot)Seguillon(at)Uhb(dot)Fr> |
---|---|
To: | PostgreSQL jdbc list <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Unicode problems. |
Date: | 2001-05-23 11:05:33 |
Message-ID: | 3B0B997D.A108AC5F@uhb.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2001-05-23 11:32:22 | Re: Unicode problems. |
Previous Message | Thomas Lockhart | 2001-05-22 23:18:48 | Re: JDBC commit to 7.1.2 |