Simple question: what is wrong here?
utf8 (CHARSET=utf8mb4) makes the internal fields larger.
What is the maximum field size for UTF8 keys? We need to guess?
create table repos(repo varchar (200), PRIMARY KEY (repo)); ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes
How hard is for
mariadb to give a better error message?
btw: The answer, by trial and error, is 191 * 4 + 4 = 767.
mariadb Ver 15.1 Distrib 10.1.47-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2