SOLVED: ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes
Published on June 10, 2017
The Ultimate Fix for MySQL/MariaDB ERROR 1071: Specified Key Was Too Long
Introduction: Bypassing the Database Bottleneck
Welcome back to Darren’s Tech Tutorials! If you’re here, you’ve likely run into one of the most frustrating database errors when trying to create a table or add an index: