From 72ef7fd0f591d1a97d42ac29ceb146b4a31a4515 Mon Sep 17 00:00:00 2001 From: edward Date: Mon, 2 Nov 2015 11:45:26 +0800 Subject: [PATCH] mysql/mysql_change_charset.sql --- mysql/mysql_change_charset.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) 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; -- 2.39.2