Re: [Firebird-devel] System UNICODE_FSS blobs vs compatibility

[Paul R. <pr...@ib...>]

On Thursday 24 May 2007 13:46, Adriano dos Santos Fernandes wrote:
> >
> > 2) Offer a SQL script that should be run after restore and which will
> > transliterate all the metadata blobs properly.
>
> I vote for this one.
> We'll need it when replacing UNICODE_FSS by UNICODE, and the user can
> run it before backup (or restore backup in V2, run script, backup
> again) before migrate to V3.
>

Actually, this is the one I would vote against :-) 

If the transliteration is a necessary part of the database it should be 
done at restore time. I think running a script to fix it is fine, as long 
as it isn't the recommended solution. By that I mean it is OK if the 
script will help a user who has forgotten to pass the correct switch 
during backup/restore. 

On the other hand, you are also thinking about a script that will 'fix' 
the database before it is backed up. That is a different thing entirely. 
I've got no problems with that. 

Anyway, my preference to solve this particular problem would be for gbak 
options that will do whatever is necessary.


Paul
-- 
Paul Reeves
http://www.ibphoenix.com
Supporting users of Firebird and InterBase