[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: case insensitive collation of Greek's sigma
From:       Tom Lane <tgl () sss ! pgh ! pa ! us>
Date:       2021-11-26 15:42:59
Message-ID: 418562.1637941379 () sss ! pgh ! pa ! us
[Download RAW message or body]

Jakub Jedelsky <jakub.jedelsky@gooddata.com> writes:
> during our tests of Postgres with ICU we found an issue with ILIKE of up=
per
> and lowercase sigma (=CE=A3). The letter has two lowercase variants =CF=83=
 and =CF=82 (at
> the end of a word). I'm working with en_US and en-US-x-icu collations an=
d
> results are a bit unexpected - they are inverted:

Not sure why you would expect en_US collation to give appropriate results
for Greek?  I think you'd need el_GR.

Be that as it may, Postgres doesn't define anything about this --- we
just rely on the collations supplied by the respective system libraries
(libc or ICU).  You'd need to file bugs against those libraries if you
think their behavior should change.

			regards, tom lane


[prev in list] [next in list] [prev in thread] [next in thread]