Re: ICU locale validation / canonicalization

From: Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>
To: Jeff Davis <pgsql(at)j-davis(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: ICU locale validation / canonicalization
Date: 2023-02-09 14:44:56
Message-ID: 9a42ad17-e8f4-083e-086f-c7aee43dfdc3@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 08.02.23 08:59, Jeff Davis wrote:
> The overall benefit here is that we keep our catalogs consistently
> using an independent standard format for ICU locale strings, rather
> than whatever the user specifies. That makes it less likely that ICU
> needs to use any fallback logic when trying to open a collator, which
> could only be bad news.

One use case is that if a user specifies a locale, say, of 'de-AT', this
might canonicalize to 'de' today, but we should still store what the
user specified because 1) that documents what the user wanted, and 2) it
might not canonicalize to the same thing tomorrow.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2023-02-09 14:57:42 Re: MacOS: xsltproc fails with "warning: failed to load external entity"
Previous Message Hayato Kuroda (Fujitsu) 2023-02-09 14:39:34 RE: [Proposal] Add foreign-server health checks infrastructure