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.