Subject | RDB$Collate_ID changing |
---|---|
Author | Roland Turcan |
Post date | 2002-03-22T09:45:12Z |
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;
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;