title: Transfer old 3.23.49 MySQL database to 5.0.51 MySQL database - Encoding in ANSI and UTF-8
body: <p>I want to transfer a 3.23.49 MySQL database to a 5.0.51 MySQL database. Now I have exported the SQL file and I'm ready for import. I looked in the sql-file and Notepad++ shows me that the files is encoded in ANSI. I looked in the values and some of them are in ANSI and some of them are in UTF-8. What is the best way to proceed?</p>
  
  <ol>
  <li>Should I change the encoding within Notepad++?</li>
  <li>Should I use <code>ALTER TABLE tbl_name CONVERT TO CHARACTER SET utf8;</code>?</li>
  <li>Should I use iconv?</li>
  <li>Do I have to look through each table and make the necessary changes?</li>
  <li>Whate are the settings for the import? MYSQL323 compatibility mode and encoding latin1?</li>
  <li>Do I have to be aware of something if the php-scripts are using another encoding?</li>
  </ol>
  
  <p>Thank you for your hints!</p>