agora inbox for pgsql-bugs@postgresql.org
help / color / mirror / Atom feedFrom: 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: Re: Re: BUG #16068: Collate of 'Norwegian Bokmål' is problematic
Date: Mon, 21 Oct 2019 10:20:53 -0400
Message-ID: <578.1571667653@sss.pgh.pa.us> (raw)
In-Reply-To: <CABbzBDCrAUu1SbkxfYHwgp_TVyrwL5_qd9VYr78hCrf4ZkDNXg@mail.gmail.com>
References: <16068-4cb6eeaa7eb46d93@postgresql.org>
<1015.1571515401@sss.pgh.pa.us>
<CABbzBDAgGVvwhvEJcwsB4vpzMknyNzBAxRSNUwMypbucphWt6w@mail.gmail.com>
<19079.1571608634@sss.pgh.pa.us>
<CABbzBDCrAUu1SbkxfYHwgp_TVyrwL5_qd9VYr78hCrf4ZkDNXg@mail.gmail.com>
Robert Ford <robfordww@gmail.com> writes:
> Sorry about this, but the version was *"Windows 2016 standard*". I let the
> installer stay on "Default locale" while installing. This results is a
> config file with the following values:
> # These settings are initialized by initdb, but they can be changed.
> lc_messages = 'Norwegian Bokmål_Norway.1252' # locale for system error
> message
Okay, so we need to translate that string to 'Norwegian_Norway' too.
That's an easy fix, but as far as I can tell from the past discussions
about this, the bugs it'll fix are distinct from what you're complaining
about here:
> WARNING: Console code page (850) differs from Windows code page (1252)
> 8-bit characters might not work correctly. See psql reference
> page "Notes for Windows users" for details.
We don't have any support for Windows code page 850. Looking at the
wikipedia page about that doesn't make me much inclined to add it
either: wikipedia says that (a) it's largely been obsoleted by 1252,
and (b) there's confusion about what the code page's contents are,
specifically whether it contains a euro sign. So my recommendation
here is just to switch your console code page to 1252.
> *postgres=# select * from pg_settings;ERROR: invalid byte sequence for
> encoding "UTF8": 0xe5 0x6c 0x5f*
That hex sequence looks suspiciously like "ål_" in CP1252, so this is an
encoding confusion problem. I think it'd go away if you simplified
these postgresql.conf entries to 'Norwegian_Norway.1252' and restarted.
What I don't remember offhand is where the funny locale name spelling
might've propagated besides these entries.
regards, tom lane
view thread (5+ messages)
Message-ID: <578.1571667653@sss.pgh.pa.us>
Permalink: ../578.1571667653@sss.pgh.pa.us/
Also on: postgresql.org/message-id/578.1571667653@sss.pgh.pa.us
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: tgl@sss.pgh.pa.us, robfordww@gmail.com, hlinnaka@iki.fi
Subject: Re: Re: Re: BUG #16068: Collate of 'Norwegian Bokmål' is problematic
In-Reply-To: <578.1571667653@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox