title: Problem with charset when inserting text into a MySQL DataBase with PHP
body: <p>I'm trying to insert text into a MySQL DataBase from a form using PHP.<br />
  Problem is, when I check the DataBase in phpmyadmin, I find that special characters like ü, ö, ä, è, é, à... are being corrupted, and I get things like <code>Ã¼Ã¶Ã¤Ã©Ã¨Ã</code>.I've tried the following:</p>
  
  <ul>
  <li>Putting <code>accept-charset="latin1_swedish_ci"</code> in the <code>&lt;form&gt;</code> tag</li>
  <li>Setting <code>default_charset = "latin1_swedish_ci"</code> in the php.ini file</li>
  <li>Putting <code>mysqli_set_charset($dbc, 'latin1_swedish_ci');</code> and <code>mysql_query('SET NAMES latin1_swedish_ci');</code> after the <code>mysqli_connect()</code> function</li>
  <li>Setting the collation of the DataBase, the table and the individual columns to <code>latin1_swedish_ci</code></li>
  </ul>
  
  <p>I noticed that running the query directly in the phpmyadmin the values weren't corrupted, so I suppose the error must be somewere in the PHP and/or the MySQL connection.<br />
  Also, I tried doing the same with <code>utf-8_general_ci</code>, and obtained same results.
  It seems to be ignoring anything I do.<br />
  Advice and ideas welcome. Thanks guys,<br />
  Sean</p>