How to convert database charset to UTF8

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. Make sure you backup your (If your database is new no need to think about that)
  2. Now open your notepad and Copy & Paste 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 to your site’s base/admin directory.
  5. Browse that file using your browser (Eg.
  6. Check for the results..

This simple php script converts all the tables to UTF8.


Related Posts

NS Weight Release

WP-Backgrounds Lite by InoPlugs Web Design and Juwelier Schönmann 1010 Wien