Message-ID: <ced6a5d0-e414-63cd-c8f4-6efe74cf4334@joeconway.com>
Date: Wed, 24 May 2023 12:31:42 -0400
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
 Thunderbird/102.11.0
Subject: Re: Order changes in PG16 since ICU introduction
Content-Language: en-US
To: Jeff Davis <pgsql@j-davis.com>, Daniel Verite <daniel@manitou-mail.org>
Cc: Matthias van de Meent <boekewurm+postgres@gmail.com>,
 Andrew Gierth <andrew@tao11.riddles.org.uk>,
 Peter Eisentraut <peter.eisentraut@enterprisedb.com>,
 Sandro Santilli <strk@kbt.io>, Tom Lane <tgl@sss.pgh.pa.us>,
 Regina Obe <lr@pcorp.us>, pgsql-hackers@lists.postgresql.org
References: <cb448574-aa7c-4969-b2dd-c9eb221d7e06@manitou-mail.org>
 <660e18263897e046e9104cc60c1cea14dc9e7551.camel@j-davis.com>
From: Joe Conway <mail@joeconway.com>
In-Reply-To: <660e18263897e046e9104cc60c1cea14dc9e7551.camel@j-davis.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: <https://www.postgresql.org/message-id/ced6a5d0-e414-63cd-c8f4-6efe74cf4334%40joeconway.com>
Precedence: bulk

On 5/24/23 11:39, Jeff Davis wrote:
> On Mon, 2023-05-22 at 22:09 +0200, Daniel Verite wrote:
>> In practice we're probably getting the "und" ICU locale whereas "fr"
>> would be appropriate.
> 
> This is a good point and illustrates that ICU is not a drop-in
> replacement for libc in all cases.
> 
> I don't see a solution here that doesn't involve some rough edges,
> though. "Locale" is a generic term, and if we continue to insist that
> it really means a libc locale, then ICU will never be on an equal
> footing with libc, let alone the preferred provider.

Huge +1

IMHO the experience should be unified to the degree possible.

-- 
Joe Conway
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com