SOQL Registered Symbol ® in where clause does not return results

Question

I have account name as XYZ®Test’s. I dont want duplicate records so when i add new account I check if it already exists using an SOQL query in apex.

Select id from Account where Name='XYZ®Test’s'

It does not return any result and allows to create duplicate whereas I want to prevent that. I cannot get rid of the registered symbol.

Also I tried adding an external Id field which has the same value to prevent duplicate but it still allows to create duplicate accounts with that symbol.

Answer 1

Salesforce thinks that your query ends at the first closing quote. If you escape that quote than your query will work. This should work for you:

SELECT Id FROM Account WHERE Name = 'XYZ®Test\'s'

You can read more about this at: https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_select_quotedstringescapes.htm

By the way. Your current query actually works. That is because you used this ` instead of ' as your second quotation mark.