Re: Possible encoding issue (win7)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: gmb <gmbouwer(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Possible encoding issue (win7)
Date: 2009-10-13 17:35:42
Message-ID: 9846.1255455342@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

gmb <gmbouwer(at)gmail(dot)com> writes:
> Using a Delphi app with ZEOS components to connect to server (on
> localhost) and get this message:
> SQL Error: invalid encoding name in PGCLIENTENCODING: WIN1252
> (Running Windows 7 (64x), postgres 8.3.7)

If the message is spelled exactly that way then it's not coming from
anything in the standard Postgres distribution --- we might say
"invalid encoding name "something"" but there's noplace that would
put a reference to PGCLIENTENCODING in the middle. I infer that the
complaint is coming from something in Delphi or ZEOS. You might have
better luck asking in support forums for those products.

FWIW, we added support for WIN1252 encoding in Postgres 8.1. One
possible theory is that this is coming from client-side code that
thinks it knows all the encodings supported by Postgres but hasn't
been updated in a long time.

> Initially I installed with server and client encoding as WIN1252. But
> since I got the error I tried an re-installing with
> locale = C, encoding = LATIN1 (server and client). But this did not
> solve the problem.

I'm thinking that this is probably driven by the locale environment on
the client side --- something is trying to set the client_encoding to
match that, and failing for some reason. So changing server encoding
wouldn't help.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Davis 2009-10-13 18:26:28 Re: Re: [GENERAL] contrib/plantuner - enable PostgreSQL planner hints
Previous Message Peter Geoghegan 2009-10-13 16:48:55 Re: Best data type to use for sales tax percent