title: MySQL Invalid UTF8 character string when importing csv table
body: <p>I want to import an .csv file into MySQL Database by:</p>
  
  <pre><code>load data local infile 'C:\\Users\\t_lichtenberger\\Desktop\\tblEnvironmentLog.csv'
  into table tblenvironmentlog
  character set utf8
  fields terminated by ';'
  lines terminated by '\n'
  ignore 1 lines;
  </code></pre>
  
  <p>The .csv file looks like:
  <a href="https://i.stack.imgur.com/9Agzl.png" rel="noreferrer"><img src="https://i.stack.imgur.com/9Agzl.png" alt="enter image description here"></a></p>
  
  <p>But I am getting the following error and I cannot explain why:</p>
  
  <pre><code>Error Code: 1300. Invalid utf8 character string: 'M'
  </code></pre>
  
  <p>Any suggestions?</p>