3
$db = mysql_connect('localhost','user','password');
if(!$db) echo "Cannot connect to the database - incorrect details";
mysql_select_db('database'); $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 "The collation of your database has been successfully changed!";
?>
I used that before to change all my tables to UTF8, save going through each table.
Can change it to anything I suppose.
make the php file, call it what you want, i used
change.php.
upload,call it in browser and run it.
Make sure you back up before you try in case you mess up.
Worked first time for me np.
Dont know any more then that, im sure other will advise if this good or bad idea.