Actions
Feature proposal #8852
closedEnsure all varchar columns with index have a length set on their indexes
Start date:
31 January 2022
Due date:
% Done:
100%
Estimated time:
Description
varchar(255) indexes will have different lengths depending on the collation since it's byte length not character length. On some collations and configurations a varchar(255) index will result in the following error.
Index column size too large. The maximum column size is 767 bytes.
Such columns should have a length supplied to their index of 50-100.
Actions