Yes, you are right. After a restore, it turns back to the default collation.

On 11/15/06, Alexandre Benson Smith <iblist@...> wrote:
>
> Fabiano Bonin wrote:
> > Can i change the default collation of a charset this way?
> >
> > update rdb$character_sets a set
> > a.rdb$default_collate_name = 'PT_BR'
> > where
> > a.rdb$character_set_name = 'ISO8859_1';
> >
> > What are the implications of such command? I see new tables are created
> > using this collation. Is there something else happening?
> >
> > Regards,
> >
> > Fabiano.
> >
>
> I think it will not survive a back-up/restore cycle
>
> see you !
>
> --
> Alexandre Benson Smith
> Development
> THOR Software e Comercial Ltda
> Santo Andre - Sao Paulo - Brazil
> www.thorsoftware.com.br
>
>
>


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