Subject Restoring database from 2.0 to 2.5 doesn't work even if -fix_fss_data is used
Author Man Gro
Hi,
I'm migrating Firebird database from version 2.0 to 2.5. The result of a
gbak restore is an error saying that there's a "malformed string", pointing
me to use -fix_fss_data and -fix_fss_metadata which I did. I couldn't find
relevant example and explanation how to use these switches so I assume
there should be a character set used for the "malformed string" (I assume
WIN1250 in my case). My gbak command looks like this:

/path/to/gbak.exe -r -rep -v -n -user SYSDBA -pas masterkey A:\backup.fbk
B:\restored.fdb -FIX_FSS_DATA WIN1250 -FIX_FSS_METADATA WIN1250

This always results in an error saying that there's a "malformed string"
and that I should use -fix_fss_data.

I also tried -FIX_FSS_DATA UTF8 but it didn't work either.

I exactly know where in the database these "malformed" characters are and
what these characters are. In hex: A8, B4 and 27. There're just couple of
them. The column is BLOB SUB_TYPE 1. Rest of the content (in this column)
is ASCII safe and the rest of the database is OK too. How can I restore
this database under Firebird 2.5?

Thank you for any advice,
Man.


[Non-text portions of this message have been removed]