Re: logfile character encoding

On 08/17/2014 03:30 AM, Redoute wrote:
> Am 16.08.2014 21:40, schrieb Tom Lane:
>
>> You need to make sure the postmaster's
>> environment selects a UTF8 locale.
>
> So is this possible at all in Windows?
> http://msdn.microsoft.com/en-us/goglobal/bb896001.aspx
> According to this table Locales support ANSI and OEM codepages, but
> there is no mention of Unicode encodings. Don't know what ANSI codepage
> "0" or OEM codepage "1" means, anyway this is not given for german or
> english language.
>
> I tried to change the lc_messages configuration variable in
> postgresql.conf. Setting has been
>
>> # These settings are initialized by initdb, but they can be changed.
>> lc_messages = 'German_Germany.1252' # locale for system error message
>
> I tried to change it to German_Germany.UTF-8, which caused a fallback to
> english messages. May be because the value is invalid at all, or may be
> because there are no translations for this locale. (BTW having messages
> in english seems to be a usable work-around, since these messages are
> ASCII only. It is also possible to manually set lc_messages back to
> 'German_Germany.1252' per session, so that the logfile contains english
> messages from the "postmaster" and UTF-8 encoded german messages from
> the sessions. But would this be a solution for default Windows
> installations?)

I am afraid Windows locale setting is a mystery to me. Here is a blog
that seems to address your issue somewhat:

http://www.g-loaded.eu/2011/02/27/locale-windows/

Hope it helps.
>
> Thank you,
> Redoute
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com