Re: ICU locale validation / canonicalization - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: ICU locale validation / canonicalization
Date
Msg-id 87fe0094-93ff-aecf-3a9f-16e228981f05@enterprisedb.com
Whole thread Raw
In response to Re: ICU locale validation / canonicalization  (Jeff Davis <pgsql@j-davis.com>)
Responses Re: ICU locale validation / canonicalization
List pgsql-hackers
On 09.02.23 22:15, Jeff Davis wrote:
> On Thu, 2023-02-09 at 15:44 +0100, Peter Eisentraut wrote:
>> One use case is that if a user specifies a locale, say, of 'de-AT',
>> this
>> might canonicalize to 'de' today,
> Canonicalization should not lose useful information, it should just
> rearrange it, so I don't see a risk here based on what I read and the
> behavior I saw. In ICU, "de-AT" canonicalizes to "de_AT" and becomes
> the language tag "de-AT".

It turns out that 'de_AT' is actually a distinct collation from 'de' in 
CLDR, so that was not the best example.  What behavior do you see for 
'de_CH'?




pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Introduce a new view for checkpointer related stats
Next
From: John Naylor
Date:
Subject: Re: [PoC] Improve dead tuple storage for lazy vacuum