Error while Auto-Update: Error: Index column size too large
one of our customer has installed TYPO3 10 on MySQL 5.6 with InnoDB. While using Auto-Update it results in
Error: Index column size too large. The maximum column size is 767 bytes.
I found following patch which may be the problem: https://github.com/TYPO3/TYPO3.CMS/commit/ef816532ef
VARCHAR (255) * UTF8 = 765 Bytes
But as UTF8-MB4 is new default we have to calculate:
VARCHAR (255) * UTF8-MB4 = 1020 Bytes, which is higher than the allowed 767 Bytes
I prefer to set this value to 190.
As TYPO3 11 requires at least MySQL 5.7 were we have a bigger allowed index the patch should only match TYPO3 10.