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? Thanks, Igal