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

From Andrew Dunstan
Subject Re: Determining client_encoding from client locale
Date
Msg-id 4A38E704.40008@dunslane.net
Whole thread Raw
In response to Determining client_encoding from client locale  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
List pgsql-hackers

Heikki Linnakangas wrote:
>
> client_encoding defaults to server_encoding, which is correct in the 
> typical environment where the client and the server have identical 
> locale settings, which I believe is why we don't see more confused 
> users on mailing lists. However, a partner of ours was recently bitten 
> by this. That was on Windows; I'm not 100% sure if LC_CTYPE is set 
> correctly there by default, but this seems like a good idea nevertheless.
>

IIRC Windows locales are not set via the environment. We've had to do 
some special hackery in a few placed to deal with that.

cheers

andrew


pgsql-hackers by date:

Previous
From: Stefan Kaltenbrunner
Date:
Subject: Re: [PATCH] backend: compare word-at-a-time in bcTruelen
Next
From: Peter Eisentraut
Date:
Subject: Re: Determining client_encoding from client locale