Our users have reported a few MySQL errors over the years but one of the most common appears to be the
ERROR 1071 (42000): Specified key was too long; max key length is xxx bytes
Where xxx is some specified value often, but not always, a value of 767.
For that reason we decided that we would make this blog entry to try and explain the situation.
We are concerned here mainly with InnoDB tables since that is what we tend to use in our extensions.