Subject Re: [firebird-support] Re: Creating index problem with collation varchar field
Author Daniel Rail
Hi,

At August 3, 2005, 07:58, Adam wrote:

> I think this error message is actually correct in this case. There is
> a limit to the size on an index in Firebird, 250something bytes from
> memory for 1.5.

Correct. Here's a website that will help in calculating the index key
size: http://www.volny.cz/iprenosil/interbase/ip_ib_indexcalculator.htm

> FB 2 significantly increases this limit again from
> memory to some percentage of the page size.

25% of page size.

--
Best regards,
Daniel Rail
Senior Software Developer
ACCRA Consultants Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)