From 0f840a80c2d82a0b8ae8ae3a5cca1c07af5bd4ff Mon Sep 17 00:00:00 2001
From: David M <davidmj@users.sourceforge.net>
Date: Sat, 17 Mar 2007 02:32:08 +0000
Subject: #4052 - utf8_general_ci picked over utf8_unicode_ci for performance
 reasons

git-svn-id: file:///svn/phpbb/trunk@7202 89ea8834-ac86-4346-8a33-228a782c2dd0
---
 phpBB/install/database_update.php | 6 ++++++
 1 file changed, 6 insertions(+)

(limited to 'phpBB/install/database_update.php')

diff --git a/phpBB/install/database_update.php b/phpBB/install/database_update.php
index acf2dc64ae..cfecb3d729 100644
--- a/phpBB/install/database_update.php
+++ b/phpBB/install/database_update.php
@@ -740,6 +740,12 @@ if (version_compare($current_version, '3.0.b4', '<='))
 
 if (version_compare($current_version, '3.0.b6', '<='))
 {
+	// sorting thang
+	if ($map_dbms === 'mysql_41')
+	{
+		sql_column_change($dbms, TOPICS_TABLE, 'topic_title', 'varchar(100) DEFAULT \'\' NOT NULL COLLATE utf8_general_ci');
+	}
+
 	if ($config['fulltext_native_common_thres'] == 20)
 	{
 		set_config('fulltext_native_common_thres', '5');
-- 
cgit v1.2.1