--- In firebird-support@yahoogroups.com, "marc_guillot"
<marc_guillot@...> wrote:

>
> Hello.
>
> I want to change all varchar fields in a database from ES_ES to
> ES_ES_AI_CI collation set.
>
> All this fields are defineds trought a few Domains, I have changed
> collation set of this Domains definition, but Fields has not been

updated.

>
> ¿ There is any command against System Tables to do it quickly ? (I
> have a lot of Tables and Fields, so I will expend a lot of time if I
> must do it manually one by one).
>
> Thank you.
>

¿ What do you think about that ? :

update RDB$RELATION_FIELDS set RDB$COLLATION_ID = 17 where
RDB$COLLATION_ID is not null;

¿ Can I have problems executing this command and doing a
Backup/Restore finally ?

Thank you.