From 702bf4a6d8597a268f6a7953a9d236a57387f7bd Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Fri, 18 Dec 2015 14:19:37 +0800 Subject: [PATCH] mysql/mysql_change_charset.sql --- mysql/mysql_change_charset.sql | 49 ++-------------------------------- 1 file changed, 2 insertions(+), 47 deletions(-) diff --git a/mysql/mysql_change_charset.sql b/mysql/mysql_change_charset.sql index 008ebf55..c2c27680 100644 --- a/mysql/mysql_change_charset.sql +++ b/mysql/mysql_change_charset.sql @@ -1,50 +1,5 @@ DROP PROCEDURE IF EXISTS mysql_change_charset; - -delimiter $$ - - -CREATE PROCEDURE mysql_change_charset(mytb TEXT) - BEGIN - DECLARE mydb TEXT; - - SELECT database() INTO mydb; - - SELECT - IF( - csname='utf8' AND collatename='utf8_unicode_ci', - CONCAT('SELECT ''',mytb,' is Already utf8'' as \"No Need to Convert\"'), - CONCAT('ALTER TABLE ',mytb,' CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci') - - ) - INTO - @ConvertEngineSQL - - FROM ( - SELECT - CCSA.character_set_name csname, - CCSA.collation_name collatename - FROM - information_schema.`TABLES` T, - information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` CCSA - WHERE - CCSA.collation_name = T.table_collation - AND - T.table_schema = mydb COLLATE utf8_unicode_ci - AND - T.table_name = mytb COLLATE utf8_unicode_ci - - - ) AA; - - -- SELECT ConvertEngineSQL; -- ??? - PREPARE st FROM @ConvertEngineSQL; - EXECUTE st; - DEALLOCATE PREPARE st; - -END; - -$$ - -DELIMITER ; \ No newline at end of file + + -- this code has been moved to PHP as we force it on all tables now.. \ No newline at end of file -- 2.39.2