Culley,
That all looks fine. I don't understand why you would be having
problems with these settings. Are you sure you are using the 7.1 jdbc
drivers? One other thing I can think of to check is to do a 'show
client_encoding'. This should also return UNICODE.
So to restate your problem, you get the 8bit characters returned as ?'s
through jdbc, but it works correctly through psql. Is this a correct
restatement of your problem?
thanks,
--Barry
Culley Harrelson wrote:
>
>
> At 11:45 AM 9/11/01 -0700, you wrote:
>
>> select getdatabaseencoding();
>
>
> UNICODE
>
>> select datname, encoding from pg_database;
>
>
> flashcard | 5
>
> All other databases on the server had 0 for encoding.
>
> Unfortunately my dev environment still has postgres 7.0. I updated my
> connection pool object and it works on dev but not on prod with 7.1. I
> really don't want to update my dev environment untill I can do the whole
> machine from scratch but I fear I might have to in order to debug this...
>
> Culley
>
>
> _________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>