title: problem with WHERE clause matching on Arabic string
body: <p>I have a SQL Server 2005 database in which I have some tables contain Arabic text. The datatype for those fields is <code>NVARCHAR(n)</code>.</p>
  
  <p>The Arabic text inside the table is appearing properly, and when selecting, they appear properly. </p>
  
  <p>Th problem is that searching for Arabic text results in 0 rows.</p>
  
  <pre><code>select * from table_name
  where name='arabic_text'
  </code></pre>
  
  <p>This retrieves no rows, where there is a name with this value. </p>
  
  <p>Can you please guide me on how to write the query?</p>