> This fails
>
> CREATE DOMAIN D_TEST AS
> CHAR(3)
> CHECK (
> VALUE IN ('T','E','S')
> )
> CHARACTER SET ASCII COLLATE ASCII

This will work:

CREATE DOMAIN D_TEST4 AS
CHAR(3) CHARACTER SET ASCII
CHECK (
VALUE IN ('T','E','S')
)
COLLATE ASCII



--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com