Ack! I guess I am hitting this problem....
I had my database rebuilt to use UNICODE encoding. Data now appears
correctly in pgsql but not when filtered through JDBC. Unfortunately Im
using the open source DbConnectionBroker connection pooling object and I
have to dig into this to apply the fix. It is suprising to me that JDBC
has a problem with a database using UNICODE encoding?!? I obviously don't
understand the internals of this stuff <grin>
culley
At 10:06 AM 9/11/01 -0700, you wrote:
>Culley,
>
>With out more details of your setup, I can't give you a complete
>answer. But check out the info at:
>
>http://lab.applinet.nl/postgresql-jdbc/#CharacterEncoding
>
>for a brief discussion of what I believe is your problem. There has also
>been a number of discussions on this on the pgsql-jdbc mail list. You
>might also want to check the mail archives.
>
>thanks,
>--Barry
>
>
>Culley Harrelson wrote:
>>The was corrupted in the process of the upgrade.
>>Is there some way to tell what the configuration options were when it was
>>installed? I am assuming by API you mean how am I accessing Postgres? JDBC.
>>Culley
>>
>>>X-Apparently-To: culleyharrelson@yahoo.com via web9605; 10 Sep 2001
>>>18:19:26 -0700 (PDT)
>>>X-Track: 1: 40
>>>To: culleyharrelson@yahoo.com
>>>Cc: pgsql-general@postgresql.org
>>>Subject: Re: [GENERAL] unicode in 7.1
>>>X-Mailer: Mew version 1.94.2 on Emacs 20.7 / Mule 4.1
>>> =?iso-2022-jp?B?KBskQjAqGyhCKQ==?=
>>>Date: Tue, 11 Sep 2001 10:19:00 +0900
>>>From: Tatsuo Ishii <t-ishii@sra.co.jp>
>>>X-Dispatcher: imput version 20000228(IM140)
>>>Lines: 9
>>>
>>> > my isp recently upgraded form postgreSQL 7.0 to 7.1. It went pretty well
>>> > but I just discovered that non-english characters are now in the database
>>> > as a question mark-- inserting non-english characters produces a ? as
>>> > well. Any idea what has gone wrong and what we need to do to fix this?
>>>
>>>Hard to tell without knowing what the configuration option was and
>>>what kind of API you are using...
>>>--
>>>Tatsuo Ishii
>>
>>_________________________________________________________
>>Do You Yahoo!?
>>Get your free @yahoo.com address at http://mail.yahoo.com
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
