title: Convert French_CI_AS (ASCII) to UTF8
body: <p>I would like to convert data from SQL Server (ASCII) to UTF-8.</p>
  
  <p>When I use the query :</p>
  
  <pre><code>SELECT SERVERPROPERTY('Collation')
  </code></pre>
  
  <p>The result is 'French_CI_AS' (So, ASCII)</p>
  
  <p>When I use DBAL from Symfony to get users from a remote database, and then, show them, it appears that the accents looks like that :</p>
  
  <p>Ang�lina</p>
  
  <p>I tried :</p>
  
  <pre><code>utf8_encode($value)
  </code></pre>
  
  <p>but it's only for ISO-8859-1...</p>
  
  <p>So I tried :</p>
  
  <pre><code>iconv("French_CI_AS", "UTF-8", $value)
  </code></pre>
  
  <p>Or :</p>
  
  <pre><code>iconv("ASCII", "UTF-8", $value)
  </code></pre>
  
  <p>but it doesn't seems to work...</p>
  
  <p>My meta template is :</p>
  
  <pre><code>&lt;meta charset="utf-8" /&gt;
  </code></pre>
  
  <p>So, any idea to convert the user names from ASCII to UTF-8 ?</p>