Hi,
i am using firebird 1.5.2
i have a problem about index creating
my field is domain base

my domain is
CREATE DOMAIN "STR100" AS VARCHAR(100) CHARACTER SET WIN1254 COLLATE PXW_TURK;

i used this domain on a field
i must create an index on this field

CREATE INDEX INDEX1 ON TABLE (STR100FIELD);

i get this error message
"key size is too big for index INDEX1"

i think the problem is about turkish collation and character set

how can i solve this problem

i can not drop the collation because turkish character sort will be wrong without the collation

best regards

ibrahim Bulut
ileti�im Online Ltd.�ti.
Software and Database Expert
Turkish Republic

[Non-text portions of this message have been removed]