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: [EMAIL PROTECTED] via web9605; 10 Sep 2001 
>>>> 18:19:26 -0700 (PDT)
>>>> X-Track: 1: 40
>>>> To: [EMAIL PROTECTED]
>>>> Cc: [EMAIL PROTECTED]
>>>> 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 <[EMAIL PROTECTED]>
>>>> 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 [EMAIL PROTECTED]
>>
> 
> 
> _________________________________________________________
> 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 [EMAIL PROTECTED]

Reply via email to