CHARACTER SET COLLATE NULL error with mySQL 4.0.27

2006-07-20 Thread thomas Armstrong
Hola. With mySQL 4.0.27 I'm trying to create this table -- CREATE TABLE `test`.`user` ( `user_id` INT UNSIGNED NOT NULL AUTO_INCREMENT , `email` TEXT CHARACTER SET COLLATE NULL , `firstname` TEXT CHARACTER SET COLLATE NOT NULL , ) -- but I get this error: -- #1064 - You have an

Re: CHARACTER SET COLLATE NULL error with mySQL 4.0.27

2006-07-20 Thread Visolve DB Team
: thomas Armstrong [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Thursday, July 20, 2006 2:41 PM Subject: CHARACTER SET COLLATE NULL error with mySQL 4.0.27 Hola. With mySQL 4.0.27 I'm trying to create this table -- CREATE TABLE `test`.`user` ( `user_id` INT UNSIGNED NOT NULL AUTO_INCREMENT