title: German Umlauts in MYSQL INSERT
body: <p>I have a problem with my mysql insert statement.
  I have a form which is submitting utf-8 characters correctly to the insert file (i've checked the POST vars).</p>
  
  <p>Now when i look after the INSERT in my DB, there are no umlauts, but question marks.</p>
  
  <p>The error must be right before the insert statement.</p>
  
  <p>If i output (manually entered) content from my DB, umlauts are correctly displayed.</p>
  
  <pre><code>// echo $_POST["title"];
  // outputs correctly with special chars: "Some german title with umlaute ä ö ü"
  
  mysql_query("INSERT INTO videos (youtube_hash, title, description, category, created) VALUES ('".mysql_real_escape_string($_POST["hash"])."', '".mysql_real_escape_string($_POST["title"])."', '".mysql_real_escape_string($_POST["desc"])."', '".mysql_real_escape_string($_POST["cat"])."', '".time()."')") or die(mysql_error());
  
  // database entry looks like this: "Some german title with umlaute ? ? ?"
  </code></pre>
  
  <p>I hope anyone can help me out in this :)</p>
  
  <p>EDIT:</p>
  
  <p><strong>htmlentities() did the job!</strong></p>