Haha!

Many thanks again!

Best regards

--- In firebird-support@yahoogroups.com, Paul Vinkenoog <paul@...> wrote:
>
> Hi emb_blaster,
>
>
> 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 ...
>
>
> Greetings,
> Paul Vinkenoog
>