Invalid XML character during changelog snapshot


The changes done with this particular commit

are a bit hard to track down the rationale, as well as what the implementation is specifically trying to remove. We encounter this problem when attempting to generate a db snapshot from postgres. The problem is the error message doesn't include what the actual `text` and/or character is that is determined to be invalid.

Instead we get an error like:
liquibase.exception.UnexpectedLiquibaseException: Invalid string encoding on column.value. To resolve, remove the invalid character on the database and try again in changeSet

with no indication of where this may be occurring. This makes it hard to diagnose.
It is also difficult to determine what codepoints are being rejected based on this:

I don't know if this is a "bug", but it is at least hard to deal with when encountered. It isn't clear what a workaround can be when you get this error message. It seems the db data itself just contains unicode code points that are being rejected.


postgres db snapshot


Mike Rodriguez


Affects versions