Subject Re: [firebird-support] Remove column attribute which overrides domain attribute
Author Helen Borrie
At 02:47 AM 11/04/2007, you wrote:

>Helen Borrie escribió:
> > Maybe in MySQL it would. :-)
> >
> > alter table mytable
> > ALTER mycolumn TYPE yourdomain
> >
> > ./heLen
> >
>Then, I need to change again, if needed, each time the domain changes.

"Each time the domain changes." This implies
that you believe domains are going to change
regularly. What, then, do you think is the
purpose of defining domains (she inquired quizzically...) ?

If, for some reason, you want to have similar
domains with a variety of collations then define
one domain for each collation you want and use
the appropriate one for defining each particular column.

>(FYI, "alter DOMAIN d_test type VARCHAR(10) CHARACTER SET ISO8859_1"
>works, but you cannot specify collate)

That's quite probable, if there is currently a
collation applied that produces smaller index
keys than the one you want to change it to. What
does it tell you when you try?

But, again, you're not meant to be changing
domain definitions on an established
database. If you need a domain with a different
set of attributes then just define it and alter
any column definitions to use that domain instead.