On Tue, 2024-07-23 at 08:49 -0400, Robert Haas wrote: > Hmm. I think we might have some unique problems due to the fact that > we rely partly on the operating system behavior, partly on libicu, > and > partly on our own internal tables.
The reliance on the OS is especially problematic for reasons that have already been discussed extensively. One of my strongest motivations for PG_C_UTF8 was that there was still a use case for libc in PG16: the "C.UTF-8" locale, which is not supported at all in ICU. Daniel Vérité made me aware of the importance of this locale, which offers code point order collation combined with Unicode ctype semantics. With PG17, between ICU and the builtin provider, there's little remaining reason to use libc (aside from legacy). Regards, Jeff Davis