Feature proposal #9010: Some database index keys not limiting their size - CB - Joomlapolis forge

Actions

Copy link

Feature proposal #9010

closed

Some database index keys not limiting their size

Added by krileon over 1 year ago. Updated over 1 year ago.

Status:

Closed

Priority:

Normal

Assignee:

krileon

Target version:

CB 2.7.4

Start date:

17 August 2022

Due date:

% Done:

100%

Estimated time:

Description

Several varchar usages are still not size limited. It's not necessary to index the full 240+ characters of a column and will error on MySQL installs not using up to date defaults due to 767 byte limit. utf8mb4_unicode_ci requires UP TO 4 bytes per character so most indexes should try to limit where needed.