From 17e5b5c2d792fea207173c23bb76636297a21a03 Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Sat, 24 May 2003 14:31:36 +0000 Subject: - 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. --- database/database.mysql | 18 +++++++++--------- 1 file changed, 9 insertions(+), 9 deletions(-) (limited to 'database/database.mysql') 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; -- cgit v1.2.3