title: SQL Server columns to support multilingual collation / characters
body: <p>I have a SQL Server database with default collation <code>Latin1_General_CI_AS</code>.
  My table's columns are of <code>nvarchar</code> or <code>ntext</code> data type.</p>
  
  <p>The database is to for a website which can be multilingual, must support at least Polish, English, later also Ukrainian and French.</p>
  
  <p>I am even struggling to make it accept Polish characters. With columns of type <code>nvarchar/ntext</code>, I can manually change a string in the database to use Polish special characters but when using <code>insert</code> or <code>UPDATE</code> statements the special characters are stripped of their accents.</p>
  
  <p>Eg. </p>
  
  <pre><code>INSERT INTO Some_Table 
  VALUES( 7, 'aśęóń', 'ąćł', 0.1, 1)
  </code></pre>
  
  <p>this ends up being 'aseón' and 'acl' in the second and third columns on <code>INSERT</code> or <code>UPDATE</code> so loses original characters.</p>
  
  <p>I have tried to set up different collation but even if the field has <code>Polish_CS_AS</code> it doesn't accept Polish chars on insert/ update.</p>
  
  <p>How to make the database to accept different language characters?</p>