[Cced: to PostgreSQL hackers list]
Alexander,
I believe this problem was fixed in the latest JDBC driver, that is
supposed to be shipped with 7.1. It asks your database which encoding
is used for particular database while connecting to the database. So
you should be able to see "select getdatabaseencoding" if you turn on
a debugging option for postmaster.
I also think the latest driver is compatible with 7.0.3, but I'm not
sure. Peter T?
--
Tatsuo Ishii
From: "Alexander Vaysman" <avaysman@numerix.com>
Subject: PostgreSQL JDBC Unicode Support
Date: Thu, 15 Mar 2001 15:34:43 -0500
Message-ID: <PFEFILJCOGAEAEJICCHBMENCCAAA.avaysman@numerix.com>
> Tatsuo,
>
> my name is Alex Vaysman, and I saw your numerous posts in the newsgroups
> regarding Postgres and mutli-language support. I have a problem with our
> Postgres database, and intensive searches on the Internet/newsgroups didn't
> provide me with an answer. I was wondering if you would know the answer or
> point me towards it.
>
> In the nutshell, we are trying to get Postgres DB running that supports
> Unicode and interacts with clients via JDBC. We have PostgreSQL version
> 7.0.3 installed. I have downloaded the latest JDBC driver from
> http://jdbc.postgresql.org.
>
> I have created a Unicode database (confirmed through \l command in psql,
> reported encoding is 'UNICODE'). In that DB I've created a table with two
> fields integer and varchar(64). Then I store a record into this table. In my
> code I specify the string through Unicode escapes. After that I retrieve
> this value and write it out. I don't get my value back but rather ?????. I'm
> attaching the code I use for reference.
>
> My Internet searches for the solution indicated that I need to apply some
> patches to JDBC driver. However, I don't know how to do that. Do you know
> where I may download the JDBC driver version with the appropriate patches
> applied? If you're using one, would you be kind enough and e-mail it to me.
> Also, having some experience with SQL Server, I know that if I wanted to
> store Unicode values into some column I was creating that column as nvarchar
> rather the varchar. Is anything like this required for Postgres?
>
> Your help is greatly appreciated. Thanks in advance,
>
> Alex Vaysman.