Subject Key size too big
Author guerrero747
Hello All:

I get this error when I try to create the following table, I have
read that the size is limited to 252 but I think the one i am defining
is shorter:

CREATE TABLE test1
(
c_o VARCHAR(25) NOT NULL COLLATE ES_ES,
c_m VARCHAR(25) NOT NULL COLLATE ES_ES,
c_u VARCHAR(25) NOT NULL COLLATE ES_ES,
CONSTRAINT pk_test1 PRIMARY KEY (c_o, c_m, c_u)
);

When I try to execute it I get:

Statement failed, SQLCODE = -607

unsuccessful metadata update
-key size too big for index PK_TEST1

SQL> show version;
ISQL Version: LI-T1.5.0.3477 Firebird 1.5 Release Candidate 3
Firebird/linux Intel (access method), version "LI-T1.5.0.3477 Firebird
1.5 Release Candidate 3"
on disk structure version 10.1

how can I solve this problem?

Thanks.