Re: Determining client_encoding from client locale - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Determining client_encoding from client locale
Date
Msg-id 26956.1245251641@sss.pgh.pa.us
Whole thread Raw
In response to Re: Determining client_encoding from client locale  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Peter Eisentraut <peter_e@gmx.net> writes:
> On Wednesday 17 June 2009 14:29:26 Heikki Linnakangas wrote:
>> We currently require that you set client_encoding correctly, or you get
>> garbage in psql and any other tool using libpq. How about setting
>> client_encoding automatically to match the client's locale? We have
>> pg_get_encoding_from_locale() function that we can use to extract the
>> encoding from LC_CTYPE. We could call that in libpq.

> I have been requesting that for years, but the Japanese users/developers 
> typically objected to that.  I think it's time to relaunch the campain, 
> though.

I think at least part of the issue is lack of confidence in our code for
extracting an encoding setting from the locale environment.  Do we
really think it's solid now, on all platforms?  The current uses of
pg_get_encoding_from_locale are all designed to put little faith in it,
and what's more it's had exactly zero non-beta field experience.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Named transaction
Next
From: Tom Lane
Date:
Subject: Re: plpgsql error message