<?php

$database_name=’dbname’;
$database_username=’dbusername’;
$database_password=’dbpassword’;

$connection = mysql_connect(‘localhost’,$database_username,$database_password);

if(!$connection) {
echo “Cannot connect to the database – incorrect details”;
}else{
mysql_select_db($database_name);
$result=mysql_query(‘show tables’);

while($tables = mysql_fetch_array($result)) {

foreach ($tables as $key => $value) {
mysql_query(“ALTER TABLE “.$value.” COLLATE utf8_general_ci”);
}
}

echo “Successfull collation change!”;

}
?>