Specified key was too long; max key length is 1000 bytes during Mysql Migration

Question

I am getting an error after changing my dialect from MySQLUnicodeDialect  to MySQL??UnicodeDialect :

Specified key was too long; max key length is 1000 bytes

What is this and how do I fix this.

 

Answer 1

This error is due to the initial attempt created MyISam tables instead of INNODB tables. 

The fix is to remove or rename the old DB and then create a new DB using the MySQL??UnicodeDialect from the database is empty.