title: MYSQL latin1 and utf8 after mysqldump
body: <p>I did a backup like that :</p>
  
  <p>Server A :
  mysqldump --all-databases -u user -ppwd --default-character-set=latin1 > backup.sql</p>
  
  <p>Server B :
  mysql -u user -ppwd --default-character-set=latin1 &lt; backup.sql</p>
  
  <p>But now, when I show datas from MYSQL with PHP, I have something like that :
  "GÃ©nÃ©ral".</p>
  
  <p>My html page is in latin1. My database is in latin1.</p>
  
  <p>If I put utf8_decode($mydata); I get the right result.
  How can I configure MYSQL to have the database results in latin1 ?</p>
  
  <p>From Server B :</p>
  
  <pre><code>mysql&gt; SHOW VARIABLES WHERE variable_name like 'char%';
  +--------------------------+----------------------------+
  | Variable_name            | Value                      |
  +--------------------------+----------------------------+
  | character_set_client     | latin1                     |
  | character_set_connection | latin1                     |
  | character_set_database   | latin1                     |
  | character_set_filesystem | binary                     |
  | character_set_results    | latin1                     |
  | character_set_server     | latin1                     |
  | character_set_system     | utf8                       |
  | character_sets_dir       | /usr/share/mysql/charsets/ |
  +--------------------------+----------------------------+
  8 rows in set (0.00 sec)
  </code></pre>