| 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: | Whole Thread | Raw Message | 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 |