hello,
i have noticed that libc collation on OpenBSD is broken (also on macos) :(
openbsd=# select n from (values
('bernard'),('bérénice'),('béatrice'),('boris')) AS l(n) order by n collate
"fr_FR"
n
----------
bernard
boris
béatrice
bérénice
(4 rows)
macos=# select n from (values ('bernard'),('bérénice'),('béatrice'),('boris'))
AS l(n) order by n collate "fr_FR";
n
----------
bernard
boris
béatrice
bérénice
(4 rows)
linux=# select n from (values ('bernard'),('bérénice'),('béatrice'),('boris'))
AS l(n) order by n collate "fr_FR"
n
------------
béatrice
bérénice
bernard
boris
(4 rows)
postgres supports ICU and this guarantees the same results on every
platform. both macos and linux link against it, i think it would be a
good addition to the openbsd port as well...
macos=# select n from (values ('bernard'),('bérénice'),('béatrice'),('boris'))
AS l(n) order by n collate "fr-FR-x-icu";
n
----------
béatrice
bérénice
bernard
boris
(4 rows)
macos=# SELECT * FROM pg_collation;
...
(861 rows)
linux=# select n from (values ('bernard'),('bérénice'),('béatrice'),('boris'))
AS l(n) order by n collate "fr-FR-x-icu";
n
------------
béatrice
bérénice
bernard
boris
(4 rows)
linux=# SELECT * FROM pg_collation;
...
(1142 rows)
openbsd=# select n from (values
('bernard'),('bérénice'),('béatrice'),('boris')) AS l(n) order by n collate
"fr-FR-x-icu";
ERROR: collation "fr-FR-x-icu" for encoding "UTF8" does not exist
LINE 1: ...nice'),('béatrice'),('boris')) AS l(n) order by n collate "f...
^
openbsd=# SELECT * FROM pg_collation;
...
(134 rows)
not sure if related but sort(1) is similarly confused (also on macos):
$ echo $LC_CTYPE
en_US.UTF-8
$ cat n
bernard
boris
béatrice
bérénice
$ sort n
bernard
boris
béatrice
bérénice
-f
--
history doesn't repeat itself. historians do.
