I cannot create the following table with a collated database.
EMPNAME should be TERRITORY_BASED collation I think, but perhaps is not initialized in time for the check constraint processing.
ij> connect 'jdbc:derby:nordb;create=true;territory=no_NO;collation=TERRITORY_BASED';
ij> CREATE TABLE STAFF9 (EMPNUM CHAR(3) NOT NULL
CONSTRAINT STAFF9_PK PRIMARY KEY,
CONSTRAINT STAFF9_EMPNAME CHECK (EMPNAME NOT LIKE 'T%'));
ERROR 42ZA2: Operand of LIKE predicate with type CHAR(20) and collation UCS_BASIC is not compatable with LIKE pattern op
erand with type CHAR(2) and collation TERRITORY_BASED.