3 DROP PROCEDURE IF EXISTS mysql_change_charset;
8 CREATE PROCEDURE mysql_change_charset(mytb TEXT)
12 SELECT database() INTO mydb;
17 csname='utf8' AND collatename='utf8_unicode_ci',
18 CONCAT('SELECT ''is Already utf8 as No Need to Convert'''),
19 CONCAT('ALTER TABLE ',mytb,' CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci')
27 CCSA.character_set_name csname,
28 CCSA.collation_name collatename
30 information_schema.`TABLES` T,
31 information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` CCSA
33 CCSA.collation_name = T.table_collation
35 T.table_schema = mydb COLLATE utf8_unicode_ci
37 T.table_name = mytb COLLATE utf8_unicode_ci
42 -- SELECT ConvertEngineSQL; -- ???
43 PREPARE st FROM @ConvertEngineSQL;
45 DEALLOCATE PREPARE st;