From bf78b6c6ea0a3c2d221f052e890964973ce1d303 Mon Sep 17 00:00:00 2001 From: edward Date: Mon, 2 Nov 2015 11:46:19 +0800 Subject: [PATCH] mysql/mysql_change_engine.sql --- mysql/mysql_change_engine.sql | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) 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) -- 2.39.2