Igal Sapir wrote: > I am trying to test a simple case insensitive comparison. Most likely the > collation that I chose is wrong, but I'm not sure how to choose the correct > one (for English/US?). Here is my snippet: > > create collation case_insensitive( > provider=icu, locale='en-US-x-icu', deterministic=false > ); > select 'Abc' = 'abc' collate case_insensitive; > > I expected true but am getting false. > > Any thoughts?
Yes, the LOCALE is wrong. Use create collation case_insensitive ( provider=icu, locale='en-US-u-ks-level2', deterministic=false ); The name of the locale defines it. My blog post can give a simple introduction: https://www.cybertec-postgresql.com/en/icu-collations-against-glibc-2-28-data-corruption/ Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
