libicu global support

2021-07-11 Thread Jakub Jedelsky
Hi, during the adoption of Centos 8 on our servers we ran into problems with Postgresql (13.3), glibc (delivered by the Centos) and performance of sorting. Because of that we're planning to use the ICU collations (en-x-icu), but the current implementation is quite complicated to adopt as there isn

case insensitive collation of Greek's sigma

2021-11-25 Thread Jakub Jedelsky
Hello, during our tests of Postgres with ICU we found an issue with ILIKE of upper and lowercase sigma (Σ). The letter has two lowercase variants σ and ς (at the end of a word). I'm working with en_US and en-US-x-icu collations and results are a bit unexpected - they are inverted: postgres=# SELE

Re: case insensitive collation of Greek's sigma

2021-12-02 Thread Jakub Jedelsky
On Wed, Dec 1, 2021 at 8:49 PM Tom Lane wrote: > Peter Eisentraut writes: > > Running lower() like this is really the wrong thing to do. We should be > > doing "case folding" instead, which normalizes these differences for the > > purpose of case-insensitive comparisons. > > That just begs the