Hi, because of the following line, dbmate up outputs the following error message when applied to a utf8mb4, innodb (version<5.7) database: Error: Error 1071: Specified key was too long; max key length is 767 bytes
|
version varchar(255) primary key)`) |
You should limit the version field to less chars (e.g 100) in order to avoid exceeding the 767 byes primary key limit (when multiplied by 4), or force a latin/utf8 encoding on the schema_migrations table ignoring the default db one. more details here: https://stackoverflow.com/a/1814594/1205281
Thanks
Hi, because of the following line,
dbmate upoutputs the following error message when applied to a utf8mb4, innodb (version<5.7) database:Error: Error 1071: Specified key was too long; max key length is 767 bytesdbmate/mysql.go
Line 112 in 7bd6947
You should limit the
versionfield to less chars (e.g 100) in order to avoid exceeding the 767 byes primary key limit (when multiplied by 4), or force a latin/utf8 encoding on theschema_migrationstable ignoring the default db one. more details here: https://stackoverflow.com/a/1814594/1205281Thanks