Subject | Restoring database from 2.0 to 2.5 doesn't work even if -fix_fss_data is used |
---|---|
Author | Man Gro |
Post date | 2013-03-26T00:23:57Z |
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]
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]