Skip site navigation (1) Skip section navigation (2)

Unicode problems.

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 (view raw or flat)
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.

Responses

pgsql-jdbc by date

Next:From: Dave CramerDate: 2001-05-23 11:32:22
Subject: Re: Unicode problems.
Previous:From: Thomas LockhartDate: 2001-05-22 23:18:48
Subject: Re: JDBC commit to 7.1.2

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group