Actions
Feature proposal #8852
closed
Ensure 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.
Updated by beat about 3 years ago
- Target version changed from CB 2.7 to CB 2.7.2
Updated by krileon about 3 years ago
- Status changed from Assigned to Rejected
- Target version deleted (
CB 2.7.2) - % Done changed from 0 to 100
There are no core tables using varchar(255) with indexes that don't have appropriate lengths set. This is likely coming from a plugin or old field that hasn't been converted to type text. Verified all core plugin tables are also fine.
Actions