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

> So the documentation is correct here: IB6 doesn't support a COLLATE clause with ALTER COLUMN -- and neither does Firebird.

A nice workaround would seem to define a domain with the desired type, charset and collation, and then alter the column's type like this:

alter table T alter MyColumn type MyCollatedDomain

...but alas, this will give MyColumn the type and charset of MyCollatedDomain, but *not* its collation.

If you add a column to T with type MyCollatedDomain, it *will* get the collation.

Just thought I'd let you know, to cheer you up ;-)

Paul Vinkenoog