Subject Re: [firebird-support] Changing collation of a existing column
Author Paul Vinkenoog
Hi Christian,

> I have to alter a column from
> varchar(n) character set ISO8859_1
> to
> varchar(n) character set ISO8859_1 collate DE_DE
> because it's not directly supported with SQL, I tried to manipulate
> the RDB$... tables. I changed in RDB$RELATION_FIELDS the column
> RDB$COLLATION_ID. That didn't have any effect on the order
> command. Do I have to change it somewhere else?

If you have an explicit index on the column, set it inactive, then
active again. This will rebuild the index.

If there is an implicit index related to a constraint, you can drop
and re-add the constraint. (Or hunt down the index name and do the
same as above - never did that myself though.)

Hope this helps,
Paul Vinkenoog