Hi to all,
i have some character encoding problems. I want to insert some data via csv and loadData into my database. In case of updating the database, everything works fine. But if i want to see the sql changes before inserting data (via outputFile), then every special character (umlaut) is replaced by ‘?’. I tried different encodings of my .csv file (utf8, iso) with setting encoding parameter inside loadData-tag. But every time the sql output of the database update task contains (a real) ‘?’ instead of the correct character (umlaut).
Does anybody know what to do for solving this issue? What encoding should i use for my csv file?
- liquibase 1.9.5
- mysql (charset latin1)