<?php
$dbname = 'dbname';
mysql_connect('127.0.0.1', 'username', 'password');
mysql_query("ALTER DATABASE `$dbname` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci");
$res = mysql_query("SHOW TABLES FROM `$dbname`");
while($row = mysql_fetch_row($res)) {
$query = "ALTER TABLE {$dbname}.`{$row[0]}` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci";
mysql_query($query);
$query = "ALTER TABLE {$dbname}.`{$row[0]}` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci";
mysql_query($query);
}
echo 'all tables converted';
?>
![[تصویر: gnsl_2.png]](http://uupload.ir/files/gnsl_2.png)
![[تصویر: czwk_3.png]](http://uupload.ir/files/czwk_3.png)
![[تصویر: bxr3_4.png]](http://uupload.ir/files/bxr3_4.png)
![[تصویر: qx2u_1.png]](http://uupload.ir/files/qx2u_1.png)
