Subject Re: [firebird-support] FB 2.5 backed-up DB cannot be restored, msg about Malformed String and "Use -FIX_FSS_DATA option."
Author Dimitry Sibiryakov
20.02.2018 16:36, dcoops@... [firebird-support] wrote:
> I've Googled a lot about this and that -FIX_FSS_DATA option seems to only really be
> relevant when restoring DBs from much earlier versions of FB - but this is from the same
> version!

Version of engine doesn't matter in this case. ODS does.
ODS used in 2.0.1 allowed malformed string literals in stored objects and data tables,
ODS for 2.5 prohibit that.
If you see this error, it means that you'd better migrate database between version by
creation of brand new database from script and then pump data from old database. During
this process you'll encounter errors that you must fix by changing script or source database.
-FIX_* switches must be used very carefully by experienced DBA only. In wrong hands
they will lead to data corruption beyond recovery.