Subject RDB$Collate_ID changing
Author Roland Turcan
Hi ALL!

I need change Collate on domain, but I tied this sql statement:

update rdb$fields set rdb$collation_id=1
where rdb$field_type=37 and rdb$character_set_id=51;

but this is executed OK, but if I tried backup/restore gbak wrote me:

key size exceeds implementation restriction for index ...
-------------
violation of FOREGN KEY contraint "PK_INDEX" on table "TABLE"
---------------
action cancelled by trieger to preserve data integrity
---------------
cannost deactivity primary index


How I change all domain in database to COLLATE PXW_CSY ?

Thank.

TRoland;