From 13aa7e2e50a5e2c6630f0e4f12265f31a19d5730 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Thu, 17 Dec 2015 14:11:39 +0800 Subject: [PATCH] UpdateDatabase/MysqlLinks.php --- UpdateDatabase/MysqlLinks.php | 1 + 1 file changed, 1 insertion(+) diff --git a/UpdateDatabase/MysqlLinks.php b/UpdateDatabase/MysqlLinks.php index 5141bf97..d4721b78 100644 --- a/UpdateDatabase/MysqlLinks.php +++ b/UpdateDatabase/MysqlLinks.php @@ -478,6 +478,7 @@ class Pman_Core_UpdateDatabase_MysqlLinks { echo "$tbl is Already utf8 \n"; continue; } + //as the default collation for stored procedure parameters is utf8_general_ci and you can't mix collations. $ce = DB_DataObject::factory('core_enum'); $ce->query("ALTER TABLE {$tbl} CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci"); -- 2.39.2