MySQL Forums
Forum List  »  Database Administration & Monitoring

Advanced Search
New Topic

Re: Upgrade Issue. Index column size too large . The maximum size is 767 bytes
Posted by: Peter Brawley
Date: May 20, 2020 04:28PM

A utf8 varchar(256) column can take up to 256*3=768 bytes, utf8mb4 1020 bytes. 767 is max for indexes. You'll need to shorten the column or the index spec.

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


Subject
Written By
Posted
Upgrade Issue. Index column size too large . The maximum size is 767 bytes
Chadwick C Hung
May 20, 2020 03:27PM
Re: Upgrade Issue. Index column size too large . The maximum size is 767 bytes
Peter Brawley
May 20, 2020 04:28PM


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.