diff options
| author | Dries Buytaert <dries@buytaert.net> | 2003-05-24 14:31:36 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2003-05-24 14:31:36 +0000 |
| commit | 17e5b5c2d792fea207173c23bb76636297a21a03 (patch) | |
| tree | b12b53d2de57af9becd243d5329c6293fe9027f2 /database/database.mysql | |
| parent | d592f76565373181afa15d99c976d168b93f6365 (diff) | |
| download | brdo-17e5b5c2d792fea207173c23bb76636297a21a03.tar.gz brdo-17e5b5c2d792fea207173c23bb76636297a21a03.tar.bz2 | |
- Changed the type of the string fields in the locale table to BLOB.
This fixes bug #987. For PostgreSQL this is not required because
its string comparisons are case-senitive. Not idea about MSSQL.
Diffstat (limited to 'database/database.mysql')
| -rw-r--r-- | database/database.mysql | 18 |
1 files changed, 9 insertions, 9 deletions
diff --git a/database/database.mysql b/database/database.mysql index d3c133e21..b1e8c2a35 100644 --- a/database/database.mysql +++ b/database/database.mysql @@ -208,15 +208,15 @@ CREATE TABLE item ( CREATE TABLE locales ( lid int(10) NOT NULL auto_increment, location varchar(128) NOT NULL default '', - string text NOT NULL, - da text NOT NULL, - fi text NOT NULL, - fr text NOT NULL, - en text NOT NULL, - es text NOT NULL, - nl text NOT NULL, - no text NOT NULL, - sw text NOT NULL, + string blob NOT NULL, + da blob NOT NULL, + fi blob NOT NULL, + fr blob NOT NULL, + en blob NOT NULL, + es blob NOT NULL, + nl blob NOT NULL, + no blob NOT NULL, + sw blob NOT NULL, PRIMARY KEY (lid) ) TYPE=MyISAM; |