Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Cannot create tables in MySQL with InnoDB and UTF8mb4 using tables_mysql.sql #6

Closed
krrg opened this issue May 2, 2016 · 2 comments
Closed

Comments

@krrg
Copy link

krrg commented May 2, 2016

InnoDB has a maximum size of 767 bytes on a single column index. When using a VARCHAR(200) as one of the columns in a multicolumn primary key, this limit still is in force.

When the character encoding is set to UTF8mb4, the VARCHAR(200) data type required 800 bytes, which is greater than the allowed 767 by InnoDB.

This should be easy to fix by reducing the VARCHAR(200) columns to VARCHAR(190) columns, which will fit inside the 767 byte limit with any encoding that uses 4 bytes or less.

For limitations on InnoDB, see http://dev.mysql.com/doc/refman/5.6/en/innodb-restrictions.html

@jhouserizer
Copy link
Contributor

See #7

@jhouserizer jhouserizer added the bug label Jun 9, 2016
@zemian
Copy link
Contributor

zemian commented Oct 13, 2016

PR merged.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants