Subject Re: [firebird-support] Bulk collate update on system tables
Author Alexandre Benson Smith
Erick Sasse wrote:
> If I want to change the collate for all my varchar fields, is it safe
> to just do a bulk update on system tables?
> Thanks.

I am smelling that you are trying to change it to collate PT_BR ;-)

When I need to do this.. I did the following:

1.) Extract metadata
2.) change all domains to use collate XYZ
3.) create an empty database with the modified collations
4.) pump the data over.

Of course it's not the quickest way of doing, but I am sure it's the
safest :-)

see you !

Alexandre Benson Smith
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil