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.

If

CREATE DOMAIN D_TEST AS
VARCHAR(10) CHARACTER SET ISO8859_1
COLLATE ES_ES_CI_AI

works fine, why not extend alter domain statement and allow

alter DOMAIN d_test type
VARCHAR(10) CHARACTER SET ISO8859_1
COLLATE ES_ES

?

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

--
Jorge Andrés Brugger
Informática
DASU - Obra Social del Personal de la Universidad Nacional de la Patagonia
Comodoro Rivadavia, Chubut, Argentina
Teléfono (0297) 446-4444 int. 103
Correo electrónico: jbrugger@...
Website: www.dasu.com.ar