3 DROP PROCEDURE IF EXISTS mysql_change_charset;
8 CREATE PROCEDURE mysql_change_charset(mytb TEXT)
12 SELECT database() INTO mydb;
18 CONCAT('SELECT ''',mytb,' is Already utf8'' as \"No Need to Convert\"'),
19 CONCAT('ALTER TABLE ',mytb,' CONVERT TO CHARACTER SET \'utf8\' ')
27 CCSA.character_set_name csname
29 information_schema.`TABLES` T,
30 information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` CCSA
32 CCSA.collation_name = T.table_collation
41 -- SELECT ConvertEngineSQL; -- ???
42 PREPARE st FROM @ConvertEngineSQL;
44 DEALLOCATE PREPARE st;