Subject Re: [firebird-support] Weird... "keysize too big for index"
Author David Johnson
Are you sure that you haven't been snagged by the one-off count? Since
the engine is written in C, byte offsets are computed from a 0 base. i
[252] is the 253rd byte.

On Tue, 2005-03-15 at 02:36, Ivan Prenosil wrote:
>
>
> > An index is limited to a maximum width of 253 characters adding all the
> > field widths in specified in the index
>
> I wonder why everybody say the limit is 253, when it is
> in fact 252 (try it yourself).
>
> To verify keysize, you can play with this Index key size calculator:
> http://www.volny.cz/iprenosil/interbase/ip_ib_indexcalculator.htm
>
> Ivan
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>