title: SQL Server where clause not returning all values with mixed characters
body: <p>Table <code>a</code> consists of value <code>' 中国-China55'</code> (exact value with space in the beginning). </p>
  
  <p>However, when I run </p>
  
  <pre><code>select * 
  from a 
  where column = N' 中国-China55'
  </code></pre>
  
  <p>Value does not get returned. </p>
  
  <p>If I replace the space and special keyboard characters with <code>''</code>, the value gets returned.</p>
  
  <p>However, I have a huge dataset I'm working with with many different special characters and nuances, so I was wondering if there is anything I can do to fix the where clause to pull back the correct value. </p>