Specified key was too long; Max Key Length is 1000 bytes

Fixing the error SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes is a very easy thing to do. That is, if you do not need to use the MyISAM storage engine. If you do not know the difference between MySQL’s storage engine MyISAM and InnoDB …

Continue reading