Hello,

> 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.

For each characterset, there's a certain collection of collations.

Try this:

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

This specifies the characterset and the collation (which is the only
collation
for this characterset anyway).

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com