On Fri, Apr 27, 2018 at 5:58 PM, Antoine Musso <hashar+wmf(a)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.
--
Brad Jorsch (Anomie)
Senior Software Engineer
Wikimedia Foundation