title: SQL Server 2008: Collation for UTF-8 code page 65001
body: <p>There is a need to save an XML in UTF-8 encoding and then use it in T-SQL code to extract data. </p>
  
  <p>Default database collation is SQL_Latin1_General_CP1_CI_AS.</p>
  
  <p>I don't know if it is possible to save and work with UTF-8 data in SQL Server 2008, but I have an idea to use collation with code page of UTF-8 (65001) on the XML column in order to save the data in UTF-8.</p>
  
  <p>Does anybody know if it is possible or have another idea on how to work with UTF-8 data in SQL Server?</p>