From: edward <edward@roojs.com>
Date: Mon, 2 Nov 2015 03:46:19 +0000 (+0800)
Subject: mysql/mysql_change_engine.sql
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=bf78b6c6ea0a3c2d221f052e890964973ce1d303

mysql/mysql_change_engine.sql
---

diff --git a/mysql/mysql_change_engine.sql b/mysql/mysql_change_engine.sql
index 43bba943..77bdabbd 100644
--- a/mysql/mysql_change_engine.sql
+++ b/mysql/mysql_change_engine.sql
@@ -41,7 +41,10 @@ CREATE PROCEDURE mysql_change_engine(mytb TEXT)
                 FROM
                     information_schema.tables
                 WHERE
-                    table_schema=mydb and table_name=mytb AND engine='InnoDB'
+                    table_schema=mydb COLLATE utf8_unicode_ci 
+                    AND 
+                    table_name=mytb COLLATE utf8_unicode_ci 
+                    AND engine='InnoDB'
             ) B
         USING
             (db,tb)