From: Eric D. Friedman <eric@etranslate.com>
To: pgsql-interfaces@postgresql.org
Subject: bug in JDBC UNICODE support
Date: Wed, 13 Sep 2000 20:38:45 -0700
Message-ID: <200009140339.UAA01240@dmz0.etranslate.com> (raw)
I built a postgresql.jar file from the HEAD of CVS on 9/13/2000.
According to the CVS logs, this includes code to support correct
handling of UNICODE (UTF-8) characters in the JDBC driver, provided
that the database is, in fact, a unicode database.
The driver simply does not work as advertised. I ran the
example.Unicode test and it confirmed the problem I encountered in my
own code by reporting that each of the strings inserted was different
from those returned by a subsequent select.
Browsing in the pgsql-interfaces archives, I found that a
user-contributed patch that DOES work and which has a bit more
intelligence about setting reasonable defaults for the encoding (it
asks the backend which encoding to use).
That patch is available at
http://www.se.postgresql.org/mhonarc/pgsql-interfaces/2000-09/msg00038.html
I believe that this patch - which is a superior implementation, I might
add - should replace the current, broken encoding handler.
Eric
P.S. I tried to submit this as a bug using the web interface for bug
reports, but that reported the following error:
Warning: Unable to connect to PostgreSQL server: No pg_hba.conf entry for host localhost, user vev, database postgresql in
/home/projects/pgsql/ftp/www/html/bugs/bugs.php on line 150
Unable to access database
It is unclear to me how to report a bug on the bug system. ;-)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: eric@etranslate.com
Subject: Re: bug in JDBC UNICODE support
In-Reply-To: <200009140339.UAA01240@dmz0.etranslate.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox