Subject | Key size too big |
---|---|
Author | guerrero747 |
Post date | 2003-06-07T10:02:40Z |
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.
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.