From 288fb832fca13a86c1a8a88bfbfd7904f3f4ad11 Mon Sep 17 00:00:00 2001 From: Alexander Ebert Date: Wed, 13 Feb 2013 15:34:07 +0100 Subject: [PATCH] Using utf8_unicode_ci instead of utf8_general_ci Fixes #1105 --- .../lib/system/database/editor/MySQLDatabaseEditor.class.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/wcfsetup/install/files/lib/system/database/editor/MySQLDatabaseEditor.class.php b/wcfsetup/install/files/lib/system/database/editor/MySQLDatabaseEditor.class.php index 135099dc30..b7b2d92b33 100644 --- a/wcfsetup/install/files/lib/system/database/editor/MySQLDatabaseEditor.class.php +++ b/wcfsetup/install/files/lib/system/database/editor/MySQLDatabaseEditor.class.php @@ -92,7 +92,7 @@ class MySQLDatabaseEditor extends DatabaseEditor { ".$columnDefinition." ".(!empty($indexDefinition) ? ',' : '')." ".$indexDefinition." - ) ENGINE=".($hasFulltextIndex ? 'MyISAM' : 'InnoDB')." DEFAULT CHARSET=utf8"; + ) ENGINE=".($hasFulltextIndex ? 'MyISAM' : 'InnoDB')." DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci"; $statement = $this->dbObj->prepareStatement($sql); $statement->execute(); } -- 2.20.1