From 26aae79daf008f8148e63370270edf9cc0afd423 Mon Sep 17 00:00:00 2001 From: edward Date: Thu, 10 Dec 2015 13:55:47 +0800 Subject: [PATCH] mysql/mysql_change_charset.sql --- mysql/mysql_change_charset.sql | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) diff --git a/mysql/mysql_change_charset.sql b/mysql/mysql_change_charset.sql index 43abd940..78a69f8c 100644 --- a/mysql/mysql_change_charset.sql +++ b/mysql/mysql_change_charset.sql @@ -14,7 +14,7 @@ CREATE PROCEDURE mysql_change_charset(mytb TEXT) SELECT IF( - csname='utf8', + 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\'') @@ -24,7 +24,8 @@ CREATE PROCEDURE mysql_change_charset(mytb TEXT) FROM ( SELECT - CCSA.character_set_name csname + CCSA.character_set_name csname, + CCSA.collation_name collatename FROM information_schema.`TABLES` T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` CCSA -- 2.39.2