function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
rhsumnerrhsumner 

Accent insensitive SOQL queries

Hi,

 

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'.

 

kurtz_wolfgangkurtz_wolfgang

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

'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.