From 2b6864df54431366e90d293bd31cd6e55654b7f7 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Wed, 23 Sep 2015 18:11:07 +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 e0c9d89f..4596be20 100644 --- a/mysql/mysql_change_charset.sql +++ b/mysql/mysql_change_charset.sql @@ -15,8 +15,8 @@ CREATE PROCEDURE mysql_change_charset(mytb TEXT) SELECT IF( dbtb2='.', - CONCAT('ALTER TABLE ',dbtb1,' ENGINE=InnoDB'), - CONCAT('SELECT ''',dbtb1,' is Already InnoDB'' as \"No Need to Convert\"') + CONCAT('ALTER TABLE ',dbtb1,' CONVERT TO CHARACTER SET \'utf8\' '), + CONCAT('SELECT ''',dbtb1,' is Already utf8'' as \"No Need to Convert\"') ) INTO @ConvertEngineSQL -- 2.39.2