Caml query with unicode charachter

Question

the caml query bellow don't return the correct result :

<Where><Eq><FieldRef Name='ParentLink' /><Value Type='Text'>ⵜⴰⵎⴰⵡⴰⵙⵜ</Value></Eq>  </Where>

i think the problem is due to the unicode charchter that i use to search. there is a solution to escape it ?

Answer 1

You need to surround the data with a CDATA tag:

<Value Type="Text"><![CDATA["ⵜⴰⵎⴰⵡⴰⵙⵜ"]]></Value>

Answer 2

Try encoding the given string before passing it to the CAML query:

string EncodeForCAML(string s)  
{           
    StringBuilder sb = new StringBuilder();  
    for (int i = 0; i < s.Length; ++i)  
    {  
        char ch = s[i];  
        if (char.IsLetterOrDigit(ch))  
            sb.Append(ch);  
        else 
            sb.AppendFormat("&#{0};", Convert.ToInt32(ch));  
    }  
    return sb.ToString();  
}  

SOURCE