Project

General

Profile

Actions

Feature proposal #8852

closed

Ensure all varchar columns with index have a length set on their indexes

Added by krileon over 2 years ago. Updated about 2 years ago.

Status:
Rejected
Priority:
Normal
Assignee:
Target version:
-
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

Also available in: Atom PDF