use stock EL9 system which comes with MariaDB 10.5 by default create a database with mysql::db (without specifying a charset/collate) run puppet several times and see corrective changes: Info: ...
latin1_f CHAR(32) CHARACTER SET latin1 COLLATE some_non_existing_col NOT NULL INSERT INTO t1 (latin1_f) VALUES (_latin1'A'); INSERT INTO t1 (latin1_f) VALUES (_latin1'a'); INSERT INTO t1 (latin1_f) ...