Re: git: 0a36787e4c1f - main - locales: separate unicode from other locales

On Tue, Apr 5, 2022 at 7:27 PM Baptiste Daroussin <bapt@freebsd.org> wrote:
> both fixed, thank you for reporting!

Thanks!

> The fact it took a year for someone to actually notice shows a lot about the
> usefulness of those locales ;)

Hehe, yeah, Catalan as spoken in Italy with a pre-UTF-8 encoding must
be pretty niche, but we open them all when you set up a new database,
so that we can snapshot the versions and then later detect when the
sorting order might have changed under our feet...  Which made me want
to check that the effects of your commit are correctly reported to
application code, and, yep, all looks good:

postgres=# select collcollate, collversion from pg_collation where
collprovider = 'c' and collversion is not null limit 10;
┌──────────────────┬─────────────┐
│   collcollate    │ collversion │
├──────────────────┼─────────────┤
│ af_ZA.ISO8859-1  │ 34.0        │
│ af_ZA.ISO8859-15 │ 34.0        │
│ af_ZA.UTF-8      │ 39.0        │
│ am_ET.UTF-8      │ 39.0        │
│ ar_AE.UTF-8      │ 39.0        │
│ ar_EG.UTF-8      │ 39.0        │
│ ar_JO.UTF-8      │ 39.0        │
│ ar_MA.UTF-8      │ 39.0        │
│ ar_QA.UTF-8      │ 39.0        │
│ ar_SA.UTF-8      │ 39.0        │
└──────────────────┴─────────────┘