I am using Liquibase to implement our DB versioning and migration. We use Postgres DBs.
I came across an error today when I ran a Changeset, SQL formatted, that added a comment to a column in a table. The comment contains some german characters with diacritics: ö, ü, ä. After the script was ran successfully, the characters with diacritics were not displayed in pgAdmin anymore, instead this � was displayed.
I specified the UTF-8 encoding in the ChangeLog file, like this: <?xml version="1.0" encoding="UTF-8"?>
and in the .cmd file that I use to call the liquibase command, like this:
call …/liquibase --url=“jdbc:postgresql://localhost:5432/dbname?useUnicode=true&characterEncoding=UTF-8” --username=postgres --password=xxxx --changeLogFile=…/ChangeLogs/dbname/updatexxxx.xml --logLevel=severe --logFile=logfile.txt update
Is there another setting or parameter I have to set to get the encoding right?