I uses JPABuddy to generate an init Liquibase db for MySQL 8.0.33 DB. I notices that for nvarchar
datatype it uses character set utf8mb3, collation utf8mb3_general_ci which are deprecated, instead MySQL recommend to use utf8mb4.
This is the responses when you try to use nvarchar:
0 row(s) affected, 1 warning(s): 3720 NATIONAL/NCHAR/NVARCHAR implies the character set UTF8MB3, which will be replaced by UTF8MB4 in a future release. Please consider using CHAR(x) CHARACTER SET UTF8MB4 in order to be unambiguous.
The solution is to change instances of nvarchar
to varchar
in the generated file, but that would defeat the purpose of Liquibase flexible changelog.