Error 1071: Specified key was too long; max key length is # bytes. # can be 1000 for MyISAM, 767 for InnoDB.
Error 1071: Specified key was too long; max key length is #
bytes. # can be 1000 for MyISAM, 767 for InnoDB.
This is by design - quote:
Prefix support and lengths of prefixes (where supported) are storage engine dependent. For example, a prefix can be up to 1000 bytes long for MyISAM tables, and 767 bytes for InnoDB tables.