From: Alan Knowles <alan@roojs.com>
Date: Wed, 23 Sep 2015 10:16:31 +0000 (+0800)
Subject: mysql/mysql_change_charset.sql
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=f39d4ebd249e54f06e5db51e494a9368daa75e20

mysql/mysql_change_charset.sql
---

diff --git a/mysql/mysql_change_charset.sql b/mysql/mysql_change_charset.sql
index 4c1c09dc..b7daf945 100644
--- 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',
-            CONCAT('SELECT ''',dbtb1,' is Already utf8'' as \"No Need to Convert\"'),
-            CONCAT('ALTER TABLE ',dbtb1,' CONVERT TO CHARACTER SET  \'utf8\' ')
+            CONCAT('SELECT ''',mytb,' is Already utf8'' as \"No Need to Convert\"'),
+            CONCAT('ALTER TABLE ',mytb,' CONVERT TO CHARACTER SET  \'utf8\' ')
             
         )
     INTO