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

mysql/mysql_change_charset.sql
---

diff --git a/mysql/mysql_change_charset.sql b/mysql/mysql_change_charset.sql
index b7daf945..46992363 100644
--- a/mysql/mysql_change_charset.sql
+++ b/mysql/mysql_change_charset.sql
@@ -31,9 +31,9 @@ CREATE PROCEDURE mysql_change_charset(mytb TEXT)
             WHERE
                 CCSA.collation_name = T.table_collation
                 AND
-                T.table_schema = mydb
+                T.table_schema = mydb COLLATE utf8_unicode_ci
                 AND
-                T.table_name = mytb
+                T.table_name = mytb COLLATE utf8_unicode_ci
 
     
     ) AA;