Cannot migrate from 5.2.4 to newer versions, "Unable to parse statement"

[joachimvda]

We are currently using 5.2.4. Using this version all our migration scripts work.

I tried upgrading to 6.4.1 (6.0.0 and 6.0.8 have the same issue).

When running our build we get the following error:

Unable to parse statement in scripts/sdd/V002__initieel_data.sql at line 217 col 1: Unknown char § encountered on line 1279 at column 73

Line 217 of the script reads:
insert into sdd_lid_controleorgaan(id, ondernemingsnummer, naamonderneming, adres_id, datumaansluiting, einddatumlidmaatschap) values (nextval('sdd_lid_controleorgaan_seq'), '0402.313.537', E'L\'ARDENNE PREVOYANTE', (select max(id) from dc_adres), '1998-02-13', null);

Line 1279 reads (the first line in the file with the ^ character:
update act_ru_identitylink set group_id_ = 'schadeadmin_dossierbeheerder§1MD8F' where group_id_ = 'a§1MD8F';

Strangely enough I seem to have other migration files with both either the escape from line 217 or with the paragraph sign from line 1279 which work.

How can I fix this?

If this is not the latest version, can you reproduce the issue with the latest one as well?

(Many bugs are fixed in newer releases and upgrading will often resolve the issue)

I tried 6.0, 6.08 and 6.4.1, all give the same problem.

Which client are you using? (Command-line, Java API, Maven plugin, Gradle plugin)

Java API

Which database are you using (type & version)?

PostgreSQL 11

Which operating system are you using?

Ubuntu Linux 20.04

What did you see instead?

Currently staying on 5.2.4