Using the datatype citext might be an alternative solution Igal Sapir <i...@lucee.org> schreef op October 8, 2019 10:51:52 PM UTC: >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
-- Verstuurd vanaf een fairphone met K-9 Mail. Excuseer mijn beknoptheid.
