On Fri, Apr 27, 2018 at 5:58 PM, Antoine Musso <[email protected]> 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
_______________________________________________
Wikitech-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikitech-l

Reply via email to