title: Unicode characters in Sql table
body: <p>I am using Sql Server 2008 R2 Enterprise. I am coding an application capable of inserting, updating, deleting and selecting records from a Sql tables. The application is making errors when it comes to the records that contain <em>special characters</em> such as ć, č š, đ and ž. </p>
  
  <p>Here's what happens:</p>
  
  <p>The command:</p>
  
  <pre><code>INSERT INTO Account (Name, Person) 
  VALUES ('Boris Borenović', 'True') 
  WHERE Id = '1'
  </code></pre>
  
  <p>inserts a new record but the Name field is <code>Boris Borenovic</code>, so character <code>ć</code> is changed to <code>c</code>.</p>
  
  <p>The command:</p>
  
  <pre><code>SELECT * FROM Account 
  WHERE Name = 'Boris Borenović'
  </code></pre>
  
  <p>returns the correct record, so again the character <code>ć</code> is replaced by <code>c</code> and the record is returned. </p>
  
  <p>Questions: </p>
  
  <ol>
  <li>Is it possible to make Sql Server save the <code>ć</code> and other <em>special characters</em> mentioned earlier? </li>
  <li>Is it still possible, if the previous question is resolved, to make Sql be able to return the <code>Boris Borenović</code> record even if the query asks for <code>Boris Borenovic</code>? </li>
  </ol>
  
  <p>So, when saving records I want Sql to save exactly what is given, but when retrieving the records, I want it to be able to ingnore the <em>special characters</em>. Thanks for all the help. </p>