#1071 - Specified key was too long; max key length is 1000 bytes

[Rob Johansen]

Why the hell does the following command fail and tell me "#1071 - Specified key was too long; max key length is 1000 bytes"?!

CREATE TABLE `db`.`table` (
`course_number` VARCHAR( 50 ) NOT NULL ,
`training_name` VARCHAR( 128 ) NOT NULL ,
`pace` TINYINT( 3 ) UNSIGNED NOT NULL ,
`topics` BOOL NOT NULL ,
`explain` TEXT ( 250 ) NULL ,
`modules` ENUM( '1', '2', '3', '4', '5', '6' ) NOT NULL ,
`voice` TINYINT( 3 ) UNSIGNED NOT NULL ,
`answers` TINYINT( 3 ) UNSIGNED NOT NULL ,
`examples` TINYINT( 3 ) UNSIGNED NOT NULL ,
`bullets` TINYINT( 3 ) UNSIGNED NOT NULL ,
`engage` TINYINT( 3 ) UNSIGNED NOT NULL ,
`stay_topic` TINYINT( 3 ) UNSIGNED NOT NULL ,
`other` TEXT ( 250 ) NULL ,
`contact` BOOL NOT NULL ,
`name` VARCHAR( 128 ) NULL ,
`email` VARCHAR( 128 ) NULL ,
`phone` VARCHAR( 128 ) NULL ,
`company` VARCHAR( 128 ) NULL ,
`date_submitted` DATE NOT NULL ,
PRIMARY KEY ( `course_number` ) ,
INDEX ( `name` , `email` , `phone` , `company` , `date_submitted` )
) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_unicode_ci

______________________________________________________________________________________________
#!/usr/bin/perl
for(74,117,115,116,32,97,110,111,116,104,101,114,32,80,101,114,108,32,104,97,99,107,101,114,44){print(chr($_))}