If you need to use UTF8 charset and want to convert your database charset to UTF8 here is a simple way to do it:

  1. Backup your database first.
  2. Open your notepad and Copy & Paste the code below:
    // Database info
    $dbhost = "localhost";
    $dbuser = "db_user";
    $dbpass = "your_dbpass";
    $dbname = "your_dbname";
    header("Content-type: text/plain");
    $dbconn = mysql_connect($dbhost, $dbuser, $dbpass) or die( mysql_error() );
    $db = mysql_select_db($dbname) or die( mysql_error() );
    $sql = "SHOW TABLES";
    $result = mysql_query($sql) or die( mysql_error() );
    while ( $row = mysql_fetch_row($result) )
    $table = mysql_real_escape_string($row[0]);
    $sql = "ALTER TABLE $table DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci, CONVERT TO CHARACTER SET utf8";
    mysql_query($sql) or die( mysql_error() );
    print "$table changed to UTF-8.n";
  3. Edit database username & password data in the code.
  4. Save that file as convert2utf8.php and upload it to your site’s base/admin directory using FTP.
  5. Navigate to that file’s URL using your web browser (Eg. http://myserver.com/convert2utf8.php)
  6. Check for the results. And voila!

This simple PHP script converts all the tables to UTF8.