Hello! I have this domain:

CREATE DOMAIN DESCR_NUEVA AS Varchar(150) CHARACTER SET ISO8859_1 DEFAULT ''
COLLATE ES_ES_CI_AI

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?

Sorry if this is a silly question !!

sergio