Subject Re: [firebird-support] Re: cannot alter column collate. does it exists in FB 2.0?
Author Paul Vinkenoog
Hi emb_blaster,

> as I feared... I was thinking in creating temporary tables copy the
> data from original ones, drop original ones. Then I can recreate with
> the correct colation and insert the data from temporary table. I don´t
> see another way... there´s any?

Just creating a new column ought to be enough. Create it with the desired collation, then:

update table MyTable set NewColumn = OldColumn

After that:

alter table MyTable drop OldColumn

Then rename the new column:

alter table MyTable alter NewColumn to OldColumn

And optionally reposition it to where the original OldColumn used to be:

alter table MyTable alter OldColumn position ...

Paul Vinkenoog