From: Tom Lane <tgl@sss.pgh.pa.us>
To: Robert Ford <robfordww@gmail.com>
cc: pgsql-bugs@lists.postgresql.org, Heikki Linnakangas <hlinnaka@iki.fi>
Subject: Re:
 =?UTF-8?Q?Re=3A_BUG_=2316068=3A_Collate_of_=27Norwegian_Bokm=C3=A5l=27_is_pr?=
 =?UTF-8?Q?oblematic?=
In-reply-to: 
 <CABbzBDAgGVvwhvEJcwsB4vpzMknyNzBAxRSNUwMypbucphWt6w@mail.gmail.com>
References: <16068-4cb6eeaa7eb46d93@postgresql.org>
 <1015.1571515401@sss.pgh.pa.us>
 <CABbzBDAgGVvwhvEJcwsB4vpzMknyNzBAxRSNUwMypbucphWt6w@mail.gmail.com>
Comments: In-reply-to Robert Ford <robfordww@gmail.com>
	message dated "Sun, 20 Oct 2019 23:40:13 +0200"
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-ID: <19078.1571608634.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Sun, 20 Oct 2019 17:57:14 -0400
Message-ID: <19079.1571608634@sss.pgh.pa.us>
Precedence: bulk

[ please keep the list cc'd ]

Robert Ford <robfordww@gmail.com> writes:
> On Sat, Oct 19, 2019, 22:03 Tom Lane <tgl@sss.pgh.pa.us> wrote:
>>> The installer sets the Collate in the config file to 'Norwegian
>>> Bokm=C3=A5l.1251' (or something similar, but notice the '=C3=A5')

>> Um, Windows-what exactly?
>> That collation name has given us trouble before, cf
>> https://git.postgresql.org/gitweb/?p=3Dpostgresql.git&a=3Dcommitdiff&h=3D=
db29620d4
>> https://git.postgresql.org/gitweb/?p=3Dpostgresql.git&a=3Dcommitdiff&h=3D=
aa1d2fc5e
>> I wonder whether Microsoft changed it again :-(

> Windows server 2012

Hm, that's not very new, and it's certainly a version we've tested.
In fact I'd have guessed the above-mentioned patches were tested
against that.

Anyway, my first thought about this is that the mapping installed by
db29620d4 looks like it will recognize 'Norwegian (Bokm=C3=A5l)' but not
'Norwegian Bokm=C3=A5l'.  Could you be more precise about exactly what
you're seeing in the config file?

			regards, tom lane