diff options
| author | David M <davidmj@users.sourceforge.net> | 2007-03-18 12:05:51 +0000 |
|---|---|---|
| committer | David M <davidmj@users.sourceforge.net> | 2007-03-18 12:05:51 +0000 |
| commit | 5e797fbb171103ef5442662281a9f89e61e54ffe (patch) | |
| tree | cfc1135bdc82f765850208652dd0416363cd7270 | |
| parent | 09e2b89917b52431d485e76087cd9d3c1f6c0be7 (diff) | |
| download | forums-5e797fbb171103ef5442662281a9f89e61e54ffe.tar forums-5e797fbb171103ef5442662281a9f89e61e54ffe.tar.gz forums-5e797fbb171103ef5442662281a9f89e61e54ffe.tar.bz2 forums-5e797fbb171103ef5442662281a9f89e61e54ffe.tar.xz forums-5e797fbb171103ef5442662281a9f89e61e54ffe.zip | |
better sorting is more important ;)
git-svn-id: file:///svn/phpbb/trunk@7206 89ea8834-ac86-4346-8a33-228a782c2dd0
| -rw-r--r-- | phpBB/develop/create_schema_files.php | 2 | ||||
| -rw-r--r-- | phpBB/install/database_update.php | 2 | ||||
| -rw-r--r-- | phpBB/install/schemas/mysql_41_schema.sql | 2 |
3 files changed, 3 insertions, 3 deletions
diff --git a/phpBB/develop/create_schema_files.php b/phpBB/develop/create_schema_files.php index 487bd792d0..f9a6af97ee 100644 --- a/phpBB/develop/create_schema_files.php +++ b/phpBB/develop/create_schema_files.php @@ -387,7 +387,7 @@ foreach ($supported_dbms as $dbms) } else if ($dbms === 'mysql_41' && $column_data[2] == 'true_sort') { - $line .= ' COLLATE utf8_general_ci'; + $line .= ' COLLATE utf8_unicode_ci'; } } diff --git a/phpBB/install/database_update.php b/phpBB/install/database_update.php index cfecb3d729..e037d26f30 100644 --- a/phpBB/install/database_update.php +++ b/phpBB/install/database_update.php @@ -743,7 +743,7 @@ 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'); + sql_column_change($dbms, TOPICS_TABLE, 'topic_title', 'varchar(100) DEFAULT \'\' NOT NULL COLLATE utf8_unicode_ci'); } if ($config['fulltext_native_common_thres'] == 20) diff --git a/phpBB/install/schemas/mysql_41_schema.sql b/phpBB/install/schemas/mysql_41_schema.sql index 4f56e3c998..07f60d816e 100644 --- a/phpBB/install/schemas/mysql_41_schema.sql +++ b/phpBB/install/schemas/mysql_41_schema.sql @@ -884,7 +884,7 @@ CREATE TABLE phpbb_topics ( topic_attachment tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, topic_approved tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, topic_reported tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, - topic_title varchar(100) DEFAULT '' NOT NULL COLLATE utf8_general_ci, + topic_title varchar(100) DEFAULT '' NOT NULL COLLATE utf8_unicode_ci, topic_poster mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, topic_time int(11) UNSIGNED DEFAULT '0' NOT NULL, topic_time_limit int(11) UNSIGNED DEFAULT '0' NOT NULL, |