Date: Wed, 6 Apr 2022 15:46:40 +1200 From: Thomas Munro <tmunro@freebsd.org> To: Baptiste Daroussin <bapt@freebsd.org> Cc: src-committers <src-committers@freebsd.org>, dev-commits-src-all@freebsd.org, dev-commits-src-main@freebsd.org Subject: Re: git: 0a36787e4c1f - main - locales: separate unicode from other locales Message-ID: <CA%2BhUKG%2BqmMW8DygN6k_KMss4Y13db-0JyU7GE5i3REJNwwq8Gw@mail.gmail.com> In-Reply-To: <20220405072723.rzjbs6phehnm46tf@aniel.nours.eu> References: <202107231506.16NF6v2h044248@gitrepo.freebsd.org> <CA%2BhUKGLZSL42hqPRJAqdThnRNNdEyN0VHg-pA34k-P9jxEwvVg@mail.gmail.com> <CA%2BhUKGJ45-9xMqksWSgQ3k00%2BWWQQy-HW3QRdKUm2t1YTxefMw@mail.gmail.com> <20220405072723.rzjbs6phehnm46tf@aniel.nours.eu>
next in thread | previous in thread | raw e-mail | index | archive | help
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 │ └──────────────────┴─────────────┘
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?CA%2BhUKG%2BqmMW8DygN6k_KMss4Y13db-0JyU7GE5i3REJNwwq8Gw>