Aaron Abend wrote:

> As I understand it, Firebird limits the total length of the items in an
> index to 252 bytes. Are there any ways to work around this limitation? We
> have some 500 character fields that need to be indexed.

Not in V1.x. You can create a 250 character field and a trigger that
populates it with the first 250 characters of you real target and index
that. Or you can create a hash of your field and index that, which will
be smaller and faster.

Why do you need to index a 500 character field?

Regards,


Ann