title: Foreign Characters Such As ü Don't Make It To Mysql
body: <p>All foreign characters such as umlauts (ü) get deleted when trying to put them into mysql.</p>
  
  <p>In debugging this problem I've went over the following:</p>
  
  <p>My database is UTF-8</p>
  
  <p>The table in question is InnoDB utf8_general_ci. Row is longtext utf8_general_ci    </p>
  
  <p>I've added <code>mysqli_set_charset($mysqli, "utf8");</code> right after <code>$mysqli = new mysqli($hostname, $username, $password, $database);</code></p>
  
  <p>It goes in using the following php:</p>
  
  <pre><code>    $stmt = $mysqli-&gt;prepare("
      UPDATE post
      SET post = ?,
      title = ?
      WHERE id = ?
      ");
      $stmt-&gt;bind_param("ssi", $clean_html, $titlePost, $id);
  </code></pre>
  
  <p>String before going being updated in db is</p>
  
  <pre><code>&lt;p&gt;SOME NEW TEXT&lt;/p&gt;&lt;p&gt; &lt;/p&gt;&lt;p&gt;üü&lt;/p&gt;
  </code></pre>
  
  <p>But still nothing. The umlauts disappear. In the DB it shows up as</p>
  
  <pre><code>&lt;p&gt;SOME NEW TEXT&lt;/p&gt;&lt;p&gt;&lt;/p&gt;&lt;p&gt;&lt;/p&gt;
  </code></pre>
  
  <p>What other debugging steps should I take? Thank you</p>