> This works on 1.5 and 2.0
>
> RECREATE TABLE TEST_1
> (
> TST CHAR(2) CHARACTER SET UTF8 COLLATE UNICODE
> );
>
> This doesn't work on 1.5 and 2.0
>
> RECREATE TABLE TEST_2
> (
> TST2 CHAR(2) NOT NULL CHARACTER SET UTF8 COLLATE UNICODE
> );

Try:

RECREATE TABLE TEST_2
(
TST2 CHAR(2) CHARACTER SET UTF8 NOT NULL COLLATE UNICODE
);




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