Re: Re: BUG #11431: Failing to backup and restore a Windows postgres database, with Norwegian Bokmål locale. - Mailing list pgsql-bugs

Noah Misch <noah@leadboat.com> writes:
> On Fri, Sep 19, 2014 at 03:15:53PM -0700, Alon wrote:
>> The pg_dump file contains this command:
>> CREATE DATABASE workgroup WITH TEMPLATE = template0 ENCODING = 'UTF8'
>> LC_COLLATE = 'Norwegian (Bokm�l)_Norway.1252' LC_CTYPE = 'Norwegian
>> (Bokm�l)_Norway.1252';

> In WIN1252, "e5 6c 29" is "�l)".  We're likely failing to set client_encoding
> at some essential point in the process.

The level of stupidity needed to use non-ASCII characters in a locale name
is breathtaking.  What were Microsoft thinking?  How are we supposed to
guess what encoding applies when setting the encoding?

            regards, tom lane