From: Alan Knowles Date: Thu, 17 Dec 2015 06:11:39 +0000 (+0800) Subject: UpdateDatabase/MysqlLinks.php X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=13aa7e2e50a5e2c6630f0e4f12265f31a19d5730 UpdateDatabase/MysqlLinks.php --- 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");