Why MySQL Isn’t My Favorite RDBMS — Reason #767

Mysql::Error: Specified key was too long; max key length is 767 bytes: CREATE UNIQUE INDEX …

Seriously!? ‘Cause no one would ever want a unique constraint on medium sized varchar column.