Hi,

>> what is the longest varchar which can be indexed? it must be less
>> than 255.

> that depends on the character set used.
> have a look at Ivan Prenosil's "index key size calculator":
> http://www.volny.cz/iprenosil/interbase/ip_ib_indexcalculator.htm

And keep in mind that for multi-byte charsets, you have to divide the
result (ie the "Remains" value) by the number of bytes per character.
That is, if you want to know the maximum indexable _string_ length.


Greetings,
Paul Vinkenoog