Sidebar

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

0 votes
31 views
asked May 13 by brandon-w-8204 (30,630 points)

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.

 

1 Answer

0 votes

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.

answered May 13 by brandon-w-8204 (30,630 points)
...