Here I was simply creating a MySQL (5.5) table when suddenly up pops the following error:
#1071 - Specified key was too long; max key length is 767 bytes
After a little trial and error, I found that since one of my
VARCHAR fields was being used for a UNIQUE index, MySQL was basically telling me that it was using too much space. When I reduced the length of this field from its initial 512 setting to 256 & then 255, it still complained. However, reducing it further to 128 fixed the issue!