"Si Carter" <simon.carter@...> wrote:

>
> I am trying to create a domain on an old database that has no default char
> set.
>
> CREATE DOMAIN DMN_FOO AS VARCHAR(100)
> NOT NULL COLLATE UNICODE_FSS;

Collations are charset specific. Also, there are no collations for charset
NONE (which is implied where you don't have a default charset).

CREATE DOMAIN DMN_FOO AS
VARCHAR(100) CHARACTER SET UNICODE_FSS
NOT NULL COLLATE UNICODE_FSS;


Dmitry