title: how to get encoding of csv file?
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/13949875/accented-characters-not-correctly-imported-with-bulk-insert">Accented characters not correctly imported with BULK INSERT</a>  </p>
  </blockquote>
  
  
  
  <p>A .net program running in my system provides me with a csv file. I would like to know the encoding of that file.</p>
  
  <p>The csv file has <code>é</code>,<code>ä</code>,<code>å</code>,<code>æ</code> characters but is shown as �(UTF8-with BOM). Is there any possibility that I can bet back these characters to its original or its English like characters.</p>
  
  <p>The csv file is created by a .net program running in the same machine under same user but after the creation of the file I cannot see the original characters. </p>
  
  <p><a href="https://stackoverflow.com/questions/13949875/is-it-possible-to-change-the-characters-not-rightly-encoded-maks-all-of-them">Related question.</a></p>
  
  <pre><code>sample data (UTF8-Without BOM) from csv file. 
  
  Pok�mon Black Version
  TGC � Nintendo
  on H�tel de R�ve  
  La Reine Masqu�e et la Tour des Miroirs 
  </code></pre>