Hello out there, I'm testing a little bit with Liquibase and stumbled upon handling german umlauts in column names. I'm trying this:
create table test (id number(5),schön varchar2(10));
Then I call Liquibase:
SQL> lb genobject -type table -name test
--Starte Liquibase am 11:34:23 (Version 4.9.1 #0, kompiliert am 2022-05-03 17:23+2221)
Aktion erfolgreich abgeschlossen. Pr³fen Sie die erstellte Datei test_table1.xml
When I now try to use the generated changelog I get this error:
SQL> lb status -changelog test_table1.xml
--Starte Liquibase am 11:35:11 (Version 4.9.1 #0, kompiliert am 2022-05-03 17:23+2221)
Invalid UTF-8 encoding.
Looking into the XML reveals that the XML header announces UTF-8 but my column name is encoded in a way that looks like WIN-1252.
Normally we do not create columns like this but sometimes the column names origin from excel an may contain these characters.