Donnie Elmore04/11/2023, 1:46 PM
when running the
2023/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.
. I am using an existing MariaDB server version
Any ideas on why this might be happening?
mysql Ver 15.1 Distrib 10.3.35-MariaDB, for Linux (x86_64) using readline 5.1
Ricardo04/11/2023, 4:06 PM
(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!)
CREATE DATABASE czech_slovak_names CHARACTER SET = 'keybcs2' COLLATE = 'keybcs2_bin';