title: UTF-8: showing correctly in database, however not in HTML despite utf-8 charset
body: <p>I use MySQL 5.1 and loaded from a UTF-8 decoded txt-file about 2.7 mil lines into a table which itself is declared as <code>utf8_unicode_ci</code> and as well all char-fields are declared as <code>utf8_unicode_ci</code>, using <code>LOAD DATA INFILE</code>...</p>
  
  <p>In the database itself the characters all seem to be correct, everything looks nice. However, when I print them using php, the characters show up as ???, although I use utf-8 declaration in the HTML head:</p>
  
  <pre><code>&lt;head&gt;
  &lt;meta http-equiv="Content-Type" content="text/html; charset=UTF-8"&gt;
  ...
  </code></pre>
  
  <p>In another table (using utf-8), where I inserted text from a submitted form, the characters appear strangely in the database, but are shown correctly again, when I print them using <code>SELECT...</code>.</p>
  
  <p>So, I was wondering: what is wrong? Are <code>UTF-8</code> chars shown correctly in the database or strangely but when you <code>SELECT</code> them again they are OK? Or where is the problem (when loading the file into the db, in the HTML or somewhere in between)??</p>
  
  <p>Thank you very much for any hint or suggestion! :)</p>