mysql/mysql_change_charset.sql

[Pman.Core] / mysql / mysql_change_charset.sql

diff --git a/mysql/mysql_change_charset.sql b/mysql/mysql_change_charset.sql
index 78a69f8..a5bea9c 100644 (file)
--- a/mysql/mysql_change_charset.sql
+++ b/mysql/mysql_change_charset.sql
@@ -15,8 +15,8 @@ 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('ALTER TABLE ',mytb,' CONVERT TO CHARACTER SET  \'utf8\' COLLATE \'utf8_unicode_ci\'')
+            CONCAT('SELECT is Already utf8 as No Need to Convert'),
+            CONCAT('ALTER TABLE ',mytb,' CONVERT TO CHARACTER SET  utf8 COLLATE utf8_unicode_ci')
             
         )
     INTO