title: Issue MySQL, PHP and CSV
body: <p>I have a problem for days with MySQL and PHP.</p>
  
  <p>I load data from a CSV and write it to a database. Unfortunately, umlauts are not displayed correctly, so a ü is written to the database as u00fc, for example.</p>
  
  <p>I use MySQL because it can not be otherwise, after establishing the MySQL connection, I execute the following commands</p>
  
  <pre><code>mysql_set_charset('UTF8', $newsystem);
  mysql_query("SET CHARACTER SET 'UTF8'", $newsystem);
  </code></pre>
  
  <p>The collation is set to utf8_general_ci.</p>
  
  <p>To enter the data, the data is converted using json_encode.</p>
  
  <p>The array is created as follows:</p>
  
  <pre><code>$jsonOrderDaten = array('id' =&gt; $daten[11], 'bezeichnung' =&gt; $daten[12], 'stueckzahl' =&gt;$daten[14], 'preis' =&gt; $daten[15], 'mwst_satz' =&gt; $daten[16]);
  </code></pre>
  
  <p>Und der MySQL Eintrag erfolgt so:</p>
  
  <pre><code>$insertquery = "INSERT INTO `e_paket` (`paket_id`, `ebay_verkaufsnr`, `adress_daten`, `bestell_daten`, `ebay_order`, `status`) VALUES ('$packid', '$ebayorderid', '$jsonKD', '$jsonOD', 1, 0)";
  
  mysql_query($insertquery ,$newsystem);
  </code></pre>
  
  <p>Can someone help me with my problem?</p>
  
  <p>Best regards,
  Pascal</p>