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?