title: MySQL LOAD DATA INFILE issue with special characters
body: <p>Im having problems with LOAD DATA LOCAL INFILE loading a utf8 file.
  The Query looks like this:</p>
  
  <pre><code>LOAD DATA LOCAL INFILE 'file.csv' INTO TABLE artikel CHARACTER SET UTF8
  FIELDS TERMINATED BY ';' ENCLOSED BY '"' LINES TERMINATED BY '\r\n';
  </code></pre>
  
  <p>But fields with special characters like "Dämmung" will be cut to "D".</p>
  
  <pre><code>SHOW VARIABLES LIKE '%_set_%';
  </code></pre>
  
  <p>Shows that it's all set to utf8, and I even used notepad++ to make sure the file is utf8.</p>
  
  <p>It would really help, if someone knows advice, it's a huge file and I would like to avoid entering the wrong fields manually :-/</p>