title: How can I store the '€' symbol in MySQL using PHP?
body: <p>I've set the PHP character set to <code>utf-8</code>:</p>
  
  <pre><code>header('Content-Type: text/html; charset=utf-8');
  </code></pre>
  
  <p>I've set the <code>currency</code> column in MySQL to <code>varchar(1)</code> with collation <code>utf8_unicode_ci</code>.</p>
  
  <p>However, the following code in PHP:</p>
  
  <pre><code>$currency = '€';
  $sql = "UPDATE myTable SET currency = '$currency' WHERE user = '$user'";
  mysql_query($sql);
  </code></pre>
  
  <p>Produces the following character in MySQL:</p>
  
  <pre><code>â
  </code></pre>
  
  <p>How can I get the <code>€</code> symbol to store properly in MySQL?</p>