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;


I get the following error

Engine Code : 335544569
Engine Message :
Dynamic SQL Error
SQL error code = -204
Data type unknown
COLLATION UNICODE_FSS is not valid for specified CHARACTER SET


Can anybody shed any light on what I'm doing wrong.

FYI I am not in a position to take the database offline as its used 24/7.

Rgds

Si Carter
http://www.fbtalk.net/ - Web Based Firebird Forum
http://www.tectsoft.net/ - Homepage