This is supposedly fixed in databases created with MySQL 5.7 and up. > MySQL 5.7 (2015) added some optimizations such as a variable length sort buffer, and als

This is supposedly fixed in databases created with MySQL 5.7 and up. > MySQL 5.7 (2015) added some optimizations such as a variable length sort buffer, and also changed InnoDB’s default row format to DYNAMIC. This allows for indexes on VARCHAR(255) with utf8mb4; something that made migrations more difficult prior. https://mysqlserverteam.com/mysql-8-0-when-to-use-utf8mb3-over-utf8mb4/ https://mysqlserverteam.com/mysql-8-0-when-to-use-utf8mb3-ov...