'; while ($row_tables = mysql_fetch_row($rs_tables)) { $table = mysql_real_escape_string($row_tables[0]); // Alter table collation // ALTER TABLE `account` DEFAULT CHARACTER SET utf8 if ($show_alter_table) echo("ALTER TABLE `$table` DEFAULT CHARACTER SET $character_set;\r\n"); $rs = mysql_query(" SHOW FULL FIELDS FROM `$table` ") or die(mysql_error()); while ($row=mysql_fetch_assoc($rs)) { if ($row['Collation'] == '' || $row['Collation'] == $convert_to) continue; // Is the field allowed to be null? if ( $row['Null'] == 'YES' ) $nullable = ' NULL '; else $nullable = ' NOT NULL'; // Does the field default to null, a string, or nothing? if ( $row['Default'] === NULL ) $default = " DEFAULT NULL"; else if ($row['Default']!='') $default = " DEFAULT '".mysql_real_escape_string($row['Default'])."'"; else $default = ''; // Alter field collation: // ALTER TABLE `tab` CHANGE `fiel` `fiel` CHAR( 5 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL if ($show_alter_field) { $field = mysql_real_escape_string($row['Field']); echo "ALTER TABLE `$table` CHANGE `$field` `$field` $row[Type] CHARACTER SET $character_set COLLATE $convert_to $nullable $default; \r\n"; } } } ?>