The field is a file path and name and is essential for certain aspects of
our application. Will version 2 support longer indexes?

Aaron


-----Original Message-----
From: Ann W. Harrison [mailto:aharrison@...]
Sent: Thursday, March 24, 2005 3:29 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Index limitations


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






Yahoo! Groups Links