From 321e7b85e9dc535c40382a8394e957162be7674f Mon Sep 17 00:00:00 2001 From: edward Date: Thu, 10 Dec 2015 14:37:39 +0800 Subject: [PATCH] UpdateDatabase/MysqlLinks.php --- UpdateDatabase/MysqlLinks.php | 18 ++++++++++++++++-- 1 file changed, 16 insertions(+), 2 deletions(-) diff --git a/UpdateDatabase/MysqlLinks.php b/UpdateDatabase/MysqlLinks.php index 99ddfebd..2988ac84 100644 --- a/UpdateDatabase/MysqlLinks.php +++ b/UpdateDatabase/MysqlLinks.php @@ -447,9 +447,23 @@ class Pman_Core_UpdateDatabase_MysqlLinks { $ce = DB_DataObject::factory('core_enum'); - print_R($ce->database());exit; + $ce->query(" + SELECT + CCSA.character_set_name csname, + CCSA.collation_name collatename + FROM + information_schema.`TABLES` T, + information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` CCSA + WHERE + CCSA.collation_name = T.table_collation + AND + T.table_schema = mydb COLLATE utf8_unicode_ci + AND + T.table_name = mytb COLLATE utf8_unicode_ci + + "); + - $ce->query("CALL mysql_change_charset('{$tbl}')"); } -- 2.39.2