title: How do I convert UTF-8 data from Classic asp Form post to UCS-2 for inserting into SQL Server 2008 r2?
body: <p>I am in the process of "modernizing" a classic asp application that uses a Access 2000 database.</p>
  
  <p>I rewrote the database on SQL Server 2008r2 and changed all of the fields to use the newer unicode enabled nchar, nvarchar, ntext and imported the old data. I also switched to IIS 7 from IIS 6</p>
  
  <p>The classic asp is collecting and writing data using UTF-8.</p>
  
  <p>Now the application shows the OLD data correctly in the web pages but as son as I touch it ie: UPDATE or INSERT the data is getting corrupted.  I assume I need to somehow convert the UTF-8 data from the classic asp to UCS-2 somehow before I write the data into SQL server.</p>
  
  <p>But how?</p>
  
  <p>NOTE: it seems that sql server auto converted the utf-8 data into a usable format when it imported the data from access.</p>