Re: Fwd: Re: unicode in 7.1

Culley,

What do you get when you issue the following select statements:

select getdatabaseencoding();
select datname, encoding from pg_database;

thanks,
--Barry

Culley Harrelson wrote:
> 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(at)yahoo(dot)com via web9605; 10 Sep 2001
>>>> 18:19:26 -0700 (PDT)
>>>> X-Track: 1: 40
>>>> To: culleyharrelson(at)yahoo(dot)com
>>>> Cc: pgsql-general(at)postgresql(dot)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(at)sra(dot)co(dot)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(at)postgresql(dot)org
>>
>
>
> _________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>