On Fri, Apr 27, 2018 at 5:58 PM, Antoine Musso hashar+wmf@free.fr wrote:
[T193222] MariaDB on Stretch uses the utf8mb4 character set. Attempting to create a key on VARCHAR(192) or larger would cause: Error: 1071 Specified key was too long; max key length is 767 bytes
Reducing the key length is the obvious solution and some fields could use to be converted to ENUM.
Personally, I'd rather we didn't use more enums. They work inconsistently for comparisons and ordering, and they require a schema change any time a new value is needed. It'd probably be better to use NameTableStore instead.