title: SQL column collation change
body: <p>I would like to change a column collation to some Polish collation and be able to view Polish characters properly. All three, original column, original table and original database, use SQL_Scandinavian_CP850_CS_AS.</p>
  
  <p>For column collation change I tried:</p>
  
  <pre><code>SELECT CAST([ColumnName] AS nvarchar(50)) COLLATE Polish_CI_AS FROM t1
  </code></pre>
  
  <p>These 3 example letters appear in Scandinavian table:</p>
  
  <pre><code>SELECT 'ØùÒ' COLLATE Polish_CI_AS
  </code></pre>
  
  <p>Should return in results <code>łŚń</code>. Instead it shows 'OuO'.</p>