Hi,

(FB RC1 / Windows2000)

The 2 following statements succeeds :

CREATE TABLE T (
ID INTEGER
, FIRST_NAME VARCHAR ( 40 )
, LAST_NAME VARCHAR ( 40 )
);

CREATE INDEX IDX_NAME ON T ( FIRST_NAME, LAST_NAME );

However, when trying the following:

CREATE TABLE T (
ID INTEGER
, FIRST_NAME VARCHAR ( 40 ) COLLATE EN_US
, LAST_NAME VARCHAR ( 40 ) COLLATE EN_US
);

CREATE INDEX IDX_NAME ON T ( FIRST_NAME, LAST_NAME );

, the CREATE INDEX fails with the following error:

ISC ERROR CODE:335544351
ISC ERROR MESSAGE:
unsuccessful metadata update
key size too big for index IDX_CARDHOLDER_NAME

What is the actual max key size for indexes?
And since the default charset is ISO8859_1, the char size should
still be equal to 1. So why did the CREATE INDEX statement fail?

Regards,

Fabrice
mailto:fabrice.aeschbacher@...