title: SQL Server unique constraint issue on unicode characters
body: <p>I have my table definition as follows:</p>
  
  <pre><code>create table [Language](
  Id int primary key identity,
  Code varchar(11) not null unique,
  NativeName nvarchar(50) not null unique
  )
  </code></pre>
  
  <p>And then, I have a long list of statements that insert into that table. The problem is that some of the insert statements conflict on my <code>NativeName</code> column's unique constraint. The weird thing is that the content is not unique at all. For example, if I only insert the following with the table empty:</p>
  
  <pre><code>insert into Language (Code, NativeName) values('am', N'አማርኛ');
  insert into Language (Code, NativeName) values('dv', N'ދިވެހިބަސް‏');
  </code></pre>
  
  <p>I get for the second insert.</p>
  
  <pre><code>Violation of UNIQUE KEY constraint 'UQ__Language__EB1957A5F98D1F9C'. Cannot insert duplicate key in object 'dbo.Language'. The duplicate key value is (ދިވެހިބަސް‏).
  </code></pre>
  
  <p>Does anyone know why unicode characters are causing these issues?</p>