title: How to fix ANSII character in SQL Server table to UTF-8
body: <p>I have a data import process to import data from csv file into a table in SQL server.</p>
  
  <p>I have noticed that some columns contain some accented characters.</p>
  
  <p>For example I have noticed the following text in the database table  </p>
  
  <blockquote>
    <p>CAFÃ‰</p>
  </blockquote>
  
  <p>I open a new file in Notepad++, change the encoding to ANSI and save the file with the above text.</p>
  
  <p>Then change encoding to UTF-8 </p>
  
  <p>The result was:</p>
  
  <blockquote>
    <p>CAFÉ</p>
  </blockquote>
  
  <p>I am not sure what has gone wrong. But is there any way to fix this problem in the database table?</p>
  
  <p>I would like to display the same CAFÉ in the database table instead of CAFÃ‰</p>
  
  <p>Because when this column is displayed on the website even the encoding is UTF-* on web pages it still shows the string as CAFÃ‰ instead of CAFÉ.</p>
  
  <p>I have also checked the collation type of the column :</p>
  
  <blockquote>
    <p>SQL_Latin1_General_CP1_CI_AS</p>
  </blockquote>
  
  <p>Thanks,</p>