Error:
Code:
PDOException: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT)
Solution:
PHP Code:
<?php
// your connection
mysql_connect("localhost","username","password");
mysql_select_db("databasename");

// convert code
$res mysql_query("SHOW TABLES");
while (
$row mysql_fetch_array($res))
{
    foreach (
$row as $key => $table)
    {
        
mysql_query("ALTER TABLE " $table " CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci");
        echo 
$key " =&gt; " $table " CONVERTED<br />";
    }
}
?>