Converting MySQL tables to Unicode - from http://daveyshafik.com/archives/166-migrating-mysql-data-to-unicode.html

convert_dbs.php

<?php
$pdo = new PDO("mysql:host=HOSTNAME", "USERNAME", "PASSWORD");

$query = $pdo->prepare("SHOW DATABASES");
$query->execute();

foreach ($query->fetchAll(PDO::FETCH_OBJ) as $row) {
    $db = $row->Database;
    echo "= $db =" . PHP_EOL;    
    $pdo->exec("USE $db");    

    // Make sure it's a database for our application
    $query = $pdo->prepare("SELECT * FROM_SOME_UNIQUE_TABLE");
    $result = $query->execute();    

    if ($result) {
        $query = $pdo->prepare("SHOW TABLES");
        $result = $query->execute();
        foreach ($query->fetchAll(PDO::FETCH_BOTH) as $row) {
            $table = $row[0];          

            echo "== $table ==", PHP_EOL;

            echo "Grabbing Schema: ";
            $query = $pdo->prepare("SHOW CREATE TABLE $table");
            $result = $query->execute();
            if (!$result) {
                exit;
            }
            echo " Done!", PHP_EOL;

            echo "Fixing Schema and Creating Temporary Table: ";
            $find = array("latin1", $table);
            $replace = array("utf8", "{$table}_utf8");
            $schema = str_replace($find, $replace, $query->fetchColumn(1));
            $query = $pdo->prepare($schema);
            $result = $query->execute();
            if (!$result) {
                exit;
            }
            echo " Done!", PHP_EOL;

            echo "Copying Data: ";
            $query = $pdo->prepare("INSERT INTO {$table}_utf8 SELECT * FROM $table");
            $result = $query->execute();
            if (!$result) {
                exit;
            }
            echo " Done!", PHP_EOL;

            echo "Deleting Original Table: ";
            $query = $pdo->prepare("DROP TABLE $table");
            $result = $query->execute();
            if (!$result) {
                exit;
            }
            echo " Done!", PHP_EOL;

            echo "Renaming Temporary Table: ";
            $query = $pdo->prepare("ALTER TABLE {$table}_utf8 RENAME TO $table");
            $result = $query->execute();
            if (!$result) {
                exit;
            }
            echo " Done!", PHP_EOL;
        }
    } else {
        echo "Skipping!", PHP_EOL;
    }
}
?>

httpd.conf

AddDefaultCharset UTF-8

set_client_to_utf8.sql

SET NAMES utf8;