Re: Fwd: Re: unicode in 7.1

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
>