title: How do you convert an xml string with UTF-8 encoding UTF-16?
body: <p>For example, say I have the following xml in a string:</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="UTF-8"?&gt;
  &lt;Stuff /&gt;
  </code></pre>
  
  <p>If I try to insert this into a SQL Server 2005 database table with an Xml column, I'll get the following error (I'm using EF 4.1, but I don't think that matters):</p>
  
  <blockquote>
    <p>XML parsing: line 1, character 38, unable to switch the encoding</p>
  </blockquote>
  
  <p>After doing some research, I learned that SQL Server expects the xml to be UTF-16. How do I convert it?</p>