Re: Fwd: Re: unicode in 7.1 - Mailing list pgsql-general

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@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
>