UTF 8 encoding not working for Postgres DB migrations

General Discussion
1

Hello,

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?

Thank you.