MySQL Unique indexes has a max key length limitation of 1000 bytes. I was attempting to build a unique index based on 2 columns but was getting this error message:
Specified key was too long; max key length is 1000 bytes
Let’s see how this can be fixed.
[Read more…]