BUG #16068: Collate of 'Norwegian Bokmål' is problematic - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #16068: Collate of 'Norwegian Bokmål' is problematic
Date
Msg-id 16068-4cb6eeaa7eb46d93@postgresql.org
Whole thread Raw
Responses Re: BUG #16068: Collate of 'Norwegian Bokmål' is problematic
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      16068
Logged by:          Robert Ford
Email address:      robfordww@gmail.com
PostgreSQL version: 12.0
Operating system:   Windows
Description:

Hi,

I want to point to an issue I discovered when installing v12.0 for windows.
The installer sets the Collate in the config file to 'Norwegian Bokmål.1251'
(or something similar, but notice the 'å')  This seems to trigger all kind
of bugs. For instance "select * from pg_settings" results in an utf8 decode
error.  PgAdmin also returns a lot of utf8 decode errors.  The problem
seemed to go away when I changed the collation to "nb_NO" and ran initdb.
This error should only occur in countries where the installer creates
Collation names with non-ascii characters, Norway is one of them.


pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #16067: Failed system call was semget
Next
From: Tomas Vondra
Date:
Subject: Re: BUG #16067: Failed system call was semget