mysql/mysql_change_charset.sql
authoredward <edward@roojs.com>
Thu, 10 Dec 2015 06:16:13 +0000 (14:16 +0800)
committeredward <edward@roojs.com>
Thu, 10 Dec 2015 06:16:13 +0000 (14:16 +0800)
mysql/mysql_change_charset.sql

index ca33995..a5bea9c 100644 (file)
@@ -15,7 +15,7 @@ CREATE PROCEDURE mysql_change_charset(mytb TEXT)
     SELECT
         IF(
             csname='utf8' AND collatename='utf8_unicode_ci',
-            CONCAT('SELECT ''',mytb,' is Already utf8'' as \"No Need to Convert\"'),
+            CONCAT('SELECT is Already utf8 as No Need to Convert'),
             CONCAT('ALTER TABLE ',mytb,' CONVERT TO CHARACTER SET  utf8 COLLATE utf8_unicode_ci')
             
         )