At 03:02 PM 30/09/2003 +0700, you wrote:

>Hi List,
>
>When trying this:
>
>CREATE TABLE TEST(
> A VARCHAR(256) NOT NULL,
> B VARCHAR(256) NOT NULL,
> C VARCHAR(256) NOT NULL,
> D VARCHAR(256) NOT NULL,
> E INTEGER,
> CONSTRAINT TEST_PK PRIMARY KEY (A, B,C,D)
>);
>
>this error statement will occur :
>
>Statement failed, SQLCODE = -607
>unsuccessful metadata update
> -key size too big for index RDB$PRIMARY80
>
>help, anybody?

256 bytes is too wide for an index: it is limited to 253 bytes (or less,
if you have a non-binary collation sequence on the column). Note BYTES not
characters.

heLen