title: mysql LOAD DATA INFILE fails with Euro sign '€'
body: <p>I'm using php and mysql <code>LOAD DATA INFILE</code> from a .csv file.<br>
  Some of the cells contain a <code>'€'</code> sign and a number and some a <code>'$'</code> sign and a number, like: 2.13€, 5.4$<br>
  When I load the csv file to the table, the cells with the <code>'$'</code> sign are inserted correctly and the cells with the <code>'€'</code> are EMPTY.<br>
  The related column is defined as the following:  </p>
  
  <pre><code>VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci
  </code></pre>
  
  <p>How can I make sure that the <code>'€'</code> sign will be inserted correctly?</p>