Subject Re: [firebird-support] Re: Restoring database from 2.0 to 2.5 doesn't work even if -fix_fss_data is used
Author Thomas Steinmaurer
> I've already spent on this more than 20 hours of my time. I had no luck so
> far.
>
> I just cannot restore the database using any of -FIX_FSS_DATA and
> -FIX_FSS_METADATA even with WIN1250, ISO8859_1 and other values.
>
> I've prepared a test case just with one table, one column and one row -
> just one database field with content from real database. I stripped the
> real 10 GB database I have to just one field with real data and made a 14
> kB backup file. The content is - dummy content, then string "WAYPOINT´S"
> and then again dummy content. I cannot restore this simple one-field
> database under Firebird 2.5 but I can restore it under Firebird 2.0. If you
> can restore it under 2.5, let me know how you did that. If you cannot, I
> will tell you how I correctly got this unrestorable content into the
> database.

What character set has your Firebird 2.0 database and what client
character set did you use for connecting when inserting the content?


--
With regards,
Thomas Steinmaurer
http://www.upscene.com/