title: Sql server string comparison problem with chinese white-space
body: <p>I have a record in my sql server database with the following value for a nvarchar column:
  '穂 坂'
  The second character is the Unicode value 0x20 which is a simple space character.</p>
  
  <p>There is a unique key constraint on that column.</p>
  
  <p>I get a unique key violation when I try to insert the following value:
  '穂　坂'
  In this string, the second character is the Unicode value 0x3000, which is a chinese space character.</p>
  
  <p>Why do I get the unique key violation? Why does sql server "convert" the chinese white-space character to a simple space?</p>
  
  <p>Thanks in advance for any insights!
  My collation is SQL_Latin1_General_CP1_CI_AS by the way.</p>