Get 'ER_TOO_LONG_KEY error running migrations in the utf8mb4 mysql database

[sequelize]

Get 'ER_TOO_LONG_KEY error running migrations in the utf8mb4 mysql database

[janmeier]

Just to clarify, the sequelizeMeta table should probably explicitly set its charset to utf8 to prevent this issue. The issue is that the unique key of 255 chars is too long for utf8mb4

[tiaozi0912]

Or there should be a way to configure the storageOptions.columnType in sequelize.js in config.json

[evantahler]

Just a note that the "common practice" (as defined by Ruby's Active Record for migrations) is that for UTF8MB4 tables, the VARCHAR key length should be shrunk from 255 to 191. This allows keys to fit in the proper space without any other error.

Here's some musings on the migration path regarding a ruby project: http://tech.taskrabbit.com/blog/2014/04/24/active-record-mysql-and-emoji/