How to retrieve data from unicode character (UTF8) using calmquery?

Question

I try to used calmquery below to retrieve data from sharepoint list column contain unicode character (UTF8) but I still cannot success result.

<Where>
  <Contains>
     <FieldRef Name='FullName' />
     <Value Type='Text'>ចាន់ សុភាព</Value>
  </Contains>

any advice please share. thanks.

Answer 1

Try using CDATA tag. Example:

<Contains>
     <FieldRef Name='FullName' />
     <Value Type='Text'>![CDATA["ចាន់ សុភាព"]]</Value>
  </Contains>

See these for more information:

How to query using CAML when a value has < in the value

Caml query with unicode charachter