Hi all,

I'm using Firebird to develop my graduation thesis and I met a
problem.
If I try to create the following table:

CREATE TABLE TEST (
Protocollo SMALLINT NOT NULL,
Host SMALLINT NOT NULL,
Porta SMALLINT NOT NULL,
Percorso VARCHAR(200) NOT NULL,
Filename VARCHAR(200) NOT NULL,
Status SMALLINT DEFAULT '0',
CONSTRAINT unico UNIQUE(Host, Percorso, Filename)
);

I get a "key size too big" error...
It seems that the problem lyies in the UNIQUE constraint (in fact,
if I keep it off, the table is correctly created).

Is there any kind of limit in the size of the fields of a CONSTRAINT
UNIQUE?

Can anybody help me?

Thank you!

Kind regards
Matteo

mailto:matteo.giacomazzi@...
ICQ# 24075529