Liquibase is latin1_swedish_ci, but should be utf8mb4_unicode_ci

Support
#1

Liquibase generates tables with latin1_swedish_ci collation instead of the wanted utf8mb4_unicode_ci on AWS Aurora. Is there a way (properties?) to set it manually (to force it) to use the utf8 collation?

I already tried to append &useUnicode=true&characterEncoding=UTF-8 to the jdbc string. Also tried to set the paramters on the database server to utf8mb4 - unfortunately with no effect.

Any ideas?

#2

Ok, looks like there was a character setting missing on the database engine itself:

alter database <schema name> character set utf8mb4 collate utf8mb4_unicode_ci;