>From: "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.

VARCHAR(1) can hold 1 character, not two. Have you tried it ?
The language used for the engine is irrelevant, because we talk
about sql layer.

Ivan

>
> 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