\n"; $result2 = mysql_query("SHOW COLUMNS FROM ".$row[0]); while ($row2 = mysql_fetch_assoc($result2)) { if (substr($row2['Type'],0,7) == 'varchar' || substr($row2['Type'],0,4) == 'text' || substr($row2['Type'],0,8) == 'longtext') { echo "ALTER TABLE `".$row[0]."` CHANGE `".$row2['Field']."` `".$row2['Field']."` ".$row2['Type']." CHARACTER SET utf8 COLLATE utf8_general_ci;
\n"; } } } mysql_free_result($result); ?>