From d7569386ba672d132d4177d30358a9fd2b527402 Mon Sep 17 00:00:00 2001 From: Alexander Ebert Date: Thu, 15 Dec 2016 01:27:40 +0100 Subject: [PATCH] Fixed charset conversion --- .../lib/system/worker/DatabaseConvertEncodingWorker.class.php | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/wcfsetup/install/files/lib/system/worker/DatabaseConvertEncodingWorker.class.php b/wcfsetup/install/files/lib/system/worker/DatabaseConvertEncodingWorker.class.php index d293bd38e2..a465887a47 100644 --- a/wcfsetup/install/files/lib/system/worker/DatabaseConvertEncodingWorker.class.php +++ b/wcfsetup/install/files/lib/system/worker/DatabaseConvertEncodingWorker.class.php @@ -54,6 +54,10 @@ class DatabaseConvertEncodingWorker extends AbstractWorker { $sql = "ALTER TABLE " . $table . " CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci"; $statement = WCF::getDB()->prepareStatement($sql); $statement->execute(); + + $sql = "ALTER TABLE " . $table . " DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci"; + $statement = WCF::getDB()->prepareStatement($sql); + $statement->execute(); } $statement = WCF::getDB()->prepareStatement("SET FOREIGN_KEY_CHECKS=1"); -- 2.20.1