MySQL Forums
Forum List  »  NDB clusters

Advanced Search
New Topic

Re: ERROR 1071 (42000): Specified key was too long; max key length is 3072 bytes
Posted by: Mikael Ronström
Date: June 08, 2018 05:54AM

The limit is 3072 bytes, a VARCHAR(2000) uses 2000 * character set width.
So if you use some complex character set it won't fit within 3072 bytes.
Workaround is to decrease to VARCHAR with smaller size.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
ERROR 1071 (42000): Specified key was too long; max key length is 3072 bytes
39777
Michele Martiello
June 06, 2018 03:33AM
Re: ERROR 1071 (42000): Specified key was too long; max key length is 3072 bytes
14450
Mikael Ronström
June 08, 2018 05:54AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.