Marius van Witzenburg We fight for our survival, we fight!

// Databases to convert to utf8
$databases = array(
    'database1' => array('localhost', 'username1', 'password'),
    'database2' => array('localhost', 'username2', 'password'),
    'database3' => array('localhost', 'username3', 'password')
);
 
foreach ($databases as $db => $db_info) {
    mysql_connect($db_info[0], $db_info[1], $db_info[2]);
    mysql_select_db($db);
    $result = mysql_query("SHOW TABLES");
 
    echo '<b>Database: ' . $db . '</b><br />';
 
    mysql_query("ALTER DATABASE " . $db . " DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci");
    while ($row = mysql_fetch_row($result)) {
        echo '-&gt; ' . $row[0] . '<br />';
        mysql_query("ALTER TABLE " . $row[0] . " CONVERT TO CHARACTER SET utf8;");
    }
}