<?php // your connection mysql_connect("localhost","DB_USER","DB_PASSWORD"); mysql_select_db("DB_NAME"); // 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_general_ci"); echo $key . " => " . $table . " CONVERTED<br />"; } } ?>