How to change the collation for all tables in a MySQL database to UTF-8?

An article by Urban    No Comments

<?php
$db = mysql_connect("localhost", "username", "pass");
if(!$db) echo "Cannot connect to the database - incorrect details";
mysql_select_db('myuser_mydbname'); $result=mysql_query('show tables');
while($tables = mysql_fetch_array($result)) {
foreach ($tables as $key => $value) {
mysql_query("ALTER TABLE $value COLLATE utf8_slovenian_ci");
}}
echo "The collation of your database has been successfully changed!";
?>