update_mysql_collation.php

<?php
/*
 Author: NewEraCracker
 License: Public Domain
*/

/* Database details */
$dbhost = '127.0.0.1';
$dbuser = 'root';
$dbpass = '123456';
$dbname = 'wordpress';

/* Collation to change to */
$dbcharset = 'utf8';
$dbcollation = 'utf8_general_ci';

/* Database globals */
$dblink = null;
$dbtype = ( function_exists('mysqli') ? 'mysqli' : ( function_exists('mysql') ? 'mysql' : null ) );

/* Function: Connect and select the database */
function db_connect()
{
	global $dbhost, $dbuser, $dbpass, $dbname, $dbtype, $dblink;

	if( $dbtype == 'mysql' )
	{
		$dblink = mysql_connect($dbhost, $dbuser, $dbpass);
		mysql_select_db($dbname, $dblink);
	}
	else if( $dbtype == 'mysqli' )
	{
		$dblink = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);
	}
}

/* Function: Query the database */
function db_query($query)
{
	global $dbtype, $dblink;

	if( $dbtype == 'mysql' )
	{
		return mysql_query($query, $dblink);
	}
	else if( $dbtype == 'mysqli' )
	{
		return mysqli_query($dblink, $query);
	}
}

/* Function: Fetch from the result */
function db_fetch($result)
{
	global $dbtype;

	if( $dbtype == 'mysql' )
	{
		return mysql_fetch_array($result);
	}
	else if( $dbtype == 'mysqli' )
	{
		return mysqli_fetch_array($result);
	}
}

/* Connect */
db_connect();

/* Change default db collation */
db_query("ALTER DATABASE {$dbname} DEFAULT CHARACTER SET {$dbcharset} DEFAULT COLLATE {$dbcollation}");

/* Grab the tables */
$show_tables_result = db_query('SHOW TABLES');

while( $tables = db_fetch($show_tables_result) )
{
	foreach( $tables as $table )
	{
		/* Change each table collation */
		db_query("ALTER TABLE {$table} CONVERT TO CHARACTER SET {$dbcharset} COLLATE {$dbcollation}");
	}
}

echo "The collation of your database has been successfully changed!";
?>