diff options
| author | David M <davidmj@users.sourceforge.net> | 2006-08-06 19:20:35 +0000 |
|---|---|---|
| committer | David M <davidmj@users.sourceforge.net> | 2006-08-06 19:20:35 +0000 |
| commit | cbd65ca2c9d59d5938e16ebdd26e1f4afdfbcd2a (patch) | |
| tree | dbd387aca660286e30ae239cda21ab0e086ba6ee /phpBB/install | |
| parent | 7c01c5ceb967d891a27341796f404370baad5c62 (diff) | |
| download | forums-cbd65ca2c9d59d5938e16ebdd26e1f4afdfbcd2a.tar forums-cbd65ca2c9d59d5938e16ebdd26e1f4afdfbcd2a.tar.gz forums-cbd65ca2c9d59d5938e16ebdd26e1f4afdfbcd2a.tar.bz2 forums-cbd65ca2c9d59d5938e16ebdd26e1f4afdfbcd2a.tar.xz forums-cbd65ca2c9d59d5938e16ebdd26e1f4afdfbcd2a.zip | |
Databases that gain cool points:
MSSQL
Firebird
SQLite
Oracle
Databases that lose cool points:
MySQL
PostgreSQL
MySQL recently-ish gained character set features. PostgreSQL has zero, none; one must create the database as unicode. The only way I can think of getting PostgreSQL to do what I want it to do would require something rather crazy...
git-svn-id: file:///svn/phpbb/trunk@6246 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install')
| -rw-r--r-- | phpBB/install/schemas/firebird_schema.sql | 2 | ||||
| -rw-r--r-- | phpBB/install/schemas/mysql_schema.sql | 2 | ||||
| -rw-r--r-- | phpBB/install/schemas/oracle_schema.sql | 2 | ||||
| -rw-r--r-- | phpBB/install/schemas/sqlite_schema.sql | 2 |
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' );; |