Hi,

> Depending on what database editor I'm using, if I create a field based on
> that DOMAIN, the generated DDL is:
>
> CREATE TABLE STOCK (
> DESCRIPCION DESCR_NUEVA /*Varchar(150) */ COLLATE ES_ES_CI_AI,
> or
> CREATE TABLE STOCK (
> DESCRIPCION DESCR_NUEVA
>
> Which is the correct way to do it? what's the difference in specifying the
> collation or just live it without specification?

AFAIK, *both* are correct. The later is better IMHO since it let's
everything to the domain definition. The former only 'overrides' the domain
collation definition, but with the same collation. So, you may use one or
another without problem.


Regards,
Anderson Farias