4 files changed, 4 insertions, 4 deletions
diff --git a/phpBB/install/schemas/firebird_schema.sql b/phpBB/install/schemas/firebird_schema.sql
index 74c6c32446..66a26fa737 100644
--- a/phpBB/install/schemas/firebird_schema.sql
+++ b/phpBB/install/schemas/firebird_schema.sql
@@ -929,7 +929,7 @@ ALTER TABLE phpbb_search_results ADD PRIMARY KEY (search_key);;
 # Table: 'phpbb_search_wordlist'
 CREATE TABLE phpbb_search_wordlist (
 	word_id INTEGER NOT NULL,
-	word_text VARCHAR(252) DEFAULT '' NOT NULL,
+	word_text VARCHAR(252) CHARACTER SET UNICODE_FSS DEFAULT '' NOT NULL,
 	word_common INTEGER DEFAULT 0 NOT NULL
 );;
 
diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql
index 8e6115120b..4c30f16adb 100644
--- a/phpBB/install/schemas/mysql_schema.sql
+++ b/phpBB/install/schemas/mysql_schema.sql
@@ -627,7 +627,7 @@ CREATE TABLE phpbb_search_results (
 # Table: 'phpbb_search_wordlist'
 CREATE TABLE phpbb_search_wordlist (
 	word_id mediumint(8) UNSIGNED NOT NULL auto_increment,
-	word_text varchar(252) BINARY DEFAULT '' NOT NULL,
+	word_text varchar(252) /*!40101 CHARACTER SET utf8 */ BINARY DEFAULT '' NOT NULL,
 	word_common tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 	PRIMARY KEY (word_id),
 	UNIQUE wrd_txt (word_text)
diff --git a/phpBB/install/schemas/oracle_schema.sql b/phpBB/install/schemas/oracle_schema.sql
index 98450307d4..ee9e65662f 100644
--- a/phpBB/install/schemas/oracle_schema.sql
+++ b/phpBB/install/schemas/oracle_schema.sql
@@ -1215,7 +1215,7 @@ CREATE TABLE phpbb_search_results (
 */
 CREATE TABLE phpbb_search_wordlist (
 	word_id number(8) NOT NULL,
-	word_text varchar2(252) DEFAULT '' ,
+	word_text nvarchar2(252) DEFAULT '' ,
 	word_common number(1) DEFAULT '0' NOT NULL,
 	CONSTRAINT pk_phpbb_search_wordlist PRIMARY KEY (word_id),
 	CONSTRAINT u_phpbb_wrd_txt UNIQUE (word_text)
diff --git a/phpBB/install/schemas/sqlite_schema.sql b/phpBB/install/schemas/sqlite_schema.sql
index 52e257edf5..f3bf39a138 100644
--- a/phpBB/install/schemas/sqlite_schema.sql
+++ b/phpBB/install/schemas/sqlite_schema.sql
@@ -606,7 +606,7 @@ CREATE TABLE phpbb_search_results (
 # Table: 'phpbb_search_wordlist'
 CREATE TABLE phpbb_search_wordlist (
 	word_id INTEGER PRIMARY KEY NOT NULL ,
-	word_text varchar(252) NOT NULL DEFAULT '',
+	word_text nvarchar(252) NOT NULL DEFAULT '',
 	word_common INTEGER UNSIGNED NOT NULL DEFAULT '0'
 );;