> > -----Original Message-----
> > CREATE DOMAIN D_FOO AS
> > VARCHAR(100) NOT NULL CHARACTER SET UNICODE_FSS COLLATE UNICODE_FSS
>
> Should have mentioned that I tried this approach as well, I get the
> following error
>
> Engine Code : 335544569
> Engine Message :
> Dynamic SQL Error
> SQL error code = -104
> Token unknown - line 2, column 24
> CHARACTER

Woops, wrong syntax :-) ... I guess that's what you get for always
using GUI tools.

Here's it again:

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

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