Zapnuti innodb_large_prefix pro MariaDB – index limits

Omlouvam se, pod profilem nevidim polozeny dotaz z minulosti.

Problematika: https://oneuptime.com/blog/post/2026-03-31-mysql-fix-error-1071-specified-key-was-too-long/view

Index exceeding limit: exceeding the 767-byte limit for VARCHAR(255) MB4 encoded
`Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes`

ROW=dynamic, utf8mb4 je pozadavek.

Muj scenar:
An exception occurred while executing ‘ALTER TABLE [TABLE_NAME] CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;’:
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes

Resenim je na serveru zapnout podporu large prefixes

Moderni systemy jiz toto vyzaduji a neni mozne je provozovat nadale bez mb4.