Noah Misch <noah(at)leadboat(dot)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 (Bokml)_Norway.1252' LC_CTYPE = 'Norwegian
>> (Bokml)_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