mysql/mysql_change_charset.sql

diff --git a/mysql/mysql_change_charset.sql b/mysql/mysql_change_charset.sql
index b7daf94..4699236 100644 (file)
--- 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;