title: Having trouble with UTF-8 storing in NVarChar in SQL Server 2008
body: <p>I'm pulling data using <code>System.Net.WebClient</code> from a web site, and when the data comes back everything parses and looks good except letters with accents. For example, when it returns an <code>é</code>, SQL Server 2008 saves it as <code>Ã©</code>.</p>
  
  <p>Just need to figure out how to convert these UTF-8 characters into something SQL Server can read. I'm storing it in an <code>NVARCHAR(MAX)</code> datatype.</p>
  
  <p>I'm using Linq-to-SQL to insert into the database if you were curious.</p>
  
  <p>Any thoughts on what I could do to convert it to the proper format?</p>