From: edward Date: Thu, 10 Dec 2015 06:16:13 +0000 (+0800) Subject: mysql/mysql_change_charset.sql X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=b3207c000012c131bb821ffe92405dd9ba9eee82 mysql/mysql_change_charset.sql --- diff --git a/mysql/mysql_change_charset.sql b/mysql/mysql_change_charset.sql index ca339956..a5bea9c1 100644 --- a/mysql/mysql_change_charset.sql +++ b/mysql/mysql_change_charset.sql @@ -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') )