From 9f24099ce0841428114894442a1382511a5bddec Mon Sep 17 00:00:00 2001 From: edward Date: Thu, 10 Dec 2015 14:29:48 +0800 Subject: [PATCH] UpdateDatabase/MysqlLinks.php --- UpdateDatabase/MysqlLinks.php | 18 +++++++++++++++--- 1 file changed, 15 insertions(+), 3 deletions(-) diff --git a/UpdateDatabase/MysqlLinks.php b/UpdateDatabase/MysqlLinks.php index bcfcc71a..00dbf51a 100644 --- a/UpdateDatabase/MysqlLinks.php +++ b/UpdateDatabase/MysqlLinks.php @@ -445,10 +445,22 @@ class Pman_Core_UpdateDatabase_MysqlLinks { echo "CALL mysql_change_charset('{$tbl}') \n"; - $ce = DB_DataObject::factory('core_enum'); - $ce->query("CALL mysql_change_charset('{$tbl}')"); - $ce->free(); + $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 + "); + } } -- 2.39.2