We have a scenario wherein we receive characters like ԄԪԥñ¿¡ from a API. We then query on a object which has a field value equal to the response. It works for most of the languages but for some characters like 'ԥ' query returns 0 rows even after maintaining the characters in respective field of object.
Please find below code :
String data = 'ԄԪԥñ¿¡';
List<Demo__c> demoLst = [SELECT resp__c FROM Demo__c WHERE resp__c = :data];
I have tried with different combinations and came to the conclusion that whenever 'ԥ' occurs in a string , query doesn't return the records.
Also , there are few more characters which i'am not able to paste in the question. Any pointers?
insert new Account(Name = 'ԥabcdefghi'); Account[] accts = [SELECT id, Name FROM Account WHERE Name = 'ԥabcdefghi'];If character is valid UTF-8, it should work fine