title: SQL LIKE statement using using unicode characters does not show correct result
body: <p>I'm using SQL Server 2008 R2. I'm just wondering why this statement doesn't work correctly. </p>
  
  <p>For example: The statement</p>
  
  <pre><code>WHERE CONTRACTORNAME LIKE '%á%' 
  </code></pre>
  
  <p>would gives me the correct result for every records containing "á". But the statement </p>
  
  <pre><code>WHERE CONTRACTORNAME LIKE '%ạ%' 
  </code></pre>
  
  <p>would not gives any records even though in <code>CONTRACTORNAME</code> column have a tons of records containing this character. Any help?</p>