title: How to INSERT & Symbol in MySQL?
body: <p>I'm inserting a CSV File into a MySQL Table. One row of the CSV file has a name with &amp; Symbol like this: </p>
  
  <pre><code>Peter &amp; Peter
  </code></pre>
  
  <p>Shortly befor the Database Insert, the echo-statement of $Variable gives "Peter &amp; Peter" and until here, String looks fine. 
  But after the Insert, Database shows: </p>
  
  <pre><code>Peter &amp;amp; Peter 
  </code></pre>
  
  <p>How can I INSERT "&amp;"-Symbol into Database? </p>
  
  <p>After Database Connection, I indicate all possible settings to UTF8:</p>
  
  <pre><code># Database Connection here
  $mysqli-&gt;query("SET NAMES 'utf8'");
  $mysqli-&gt;set_charset("utf8");
  $charset = $mysqli-&gt;character_set_name();
  printf ("Current character set is %s\n", $charset);
  </code></pre>
  
  <p>Database parameters: </p>
  
  <ul>
  <li>Current character set is utf8</li>
  <li>Column type is varchar(200)</li>
  <li>The DB-Table is "utf8_general_ci" and </li>
  <li>all Fields of the Table are also set to Collation "utf8_general_ci"</li>
  </ul>
  
  <p>How can I INSERT "&amp;"-Symbol into Database?</p>