| Subject | Re: [firebird-support] cannot alter column collate. does it exists in FB 2.0? |
|---|---|
| Author | Paul Vinkenoog |
| Post date | 2009-01-28T00:42:56Z |
Hi,
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
> 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