function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

Accent insensitive SOQL queries



Is there anyway to ensure my SOQL query results are accent insensitive, that is, when I run the query:



[SELECT Id, FirstName, LastName FROM Contact
where firstname like 'jorg']


I would like the results to include both contacts whose first name is 'Jorg' or 'Jörg'.



That's basically 'Jorg' or 'Joerg' in ASCII and moreover aren't those two different characters?


'Jorg' was just an example. I have lots of field values that have umlauts in them. I am looking to make the query accent insensitive much like you can do in SQL and MySQL.