[snip] `user_id` mediumint(8) unsigned NOT NULL default '0', `group_id` mediumint(8) unsigned NOT NULL default '0', `quota_type` smallint(2) NOT NULL default '0', `quota_limit_id` mediumint(8) unsigned NOT NULL default '0', KEY `quota_type` (`quota_type`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; [/snip]
[snip from earlier e-mail] The mySQL version is: 4.0.22 [/snip] Quote from http://dev.mysql.com/doc/mysql/en/create-table.html "As of MySQL 4.1, character column definitions can include a CHARACTER SET attribute to specify the character set and, optionally, a collation for the column. For details, see Chapter 10, Character Set Support. CHARSET is a synonym for CHARACTER SET. CREATE TABLE t (c CHAR(20) CHARACTER SET utf8 COLLATE utf8_bin);" CHARSET is not supported in your version of MySQL -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
