SQL Like operator do not return data with Arabic characters
<p>I have a query statement that uses "LIKE" operator to retrieve search result from Oracle database that contains Arabic &amp; English data. It works like a charm with English characters after the "LIKE", but it retrieves 0 records with Arabic characters.</p>

<p>here is simplified code of mine:</p>

<pre><code>String whereSt = " WHERE Arb_NAME LIKE '%محمد' "; //Generated from caller method 
String selectSt = " Select * from Users " + whereSt;
DynamicDBTable dDBT = new DynamicDBTable(this.dbConn, TableSpace.Users);
 dDBT.SelectRecords(selectST,prm);
DataSet result = dDBT.FetchData();
</code></pre>

<p>the strange thing that When I copy the (selectST) to the SQL Developer it works well with both Arabic and English.</p>

<p>any help will be appreciated. </p>