title: XML data in ntext to xml data type
body: <p>I'm a rookie when it comes to XML data.</p>
  
  <p>I currently have a database with xml data being stored in a <code>ntext</code> column and this database appears to be taking up too much space. I'm trying to improve the way the data is stored, to reduce the overall size of the DB.</p>
  
  <p>The way I see it, I have two options:</p>
  
  <ul>
  <li><code>nvarchar(max)</code></li>
  <li><code>xml</code></li>
  </ul>
  
  <p>I will need to test the two options above by importing some data into those columns.</p>
  
  <p>The problem I am having is, the XML data in the ntext column is currently stored as utf-8. In order for me to import it into the XML data type column, I will need to CAST/CONVERT the data to UTF-16?</p>
  
  <p>Is this right?</p>