MySQL Forums
Forum List  »  NDB clusters

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: ERROR 1071 (42000): Specified key was too long; max key length is 3072 bytes
13207
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.