Donnie Elmore
04/11/2023, 1:46 PM2023/04/11 09:44:46 FAIL 20230315104937_EnsureUniformCollation.go (fixing software table: aggregating dupes: Error 1253: COLLATION 'utf8mb4_unicode_ci' is not valid for CHARACTER SET 'latin1'), quitting migration.
when running the prepare db
. I am using an existing MariaDB server version
mysql Ver 15.1 Distrib 10.3.35-MariaDB, for Linux (x86_64) using readline 5.1
Any ideas on why this might be happening?Ricardo
04/11/2023, 4:06 PMCREATE DATABASE czech_slovak_names
CHARACTER SET = 'keybcs2'
COLLATE = 'keybcs2_bin';
(from the mariadb website)
So just make sure you create the database with the proper collation/character settings.
(I am uncertain if this prepare db would create the database as well or just write into an existing one - if it creates the database as well - then it should take care of both server flags and act accordingly => could be a potential bug!)