> > Please remind me, what is the max key size in FIrebird 1.5?
> >
> > I just failed to create a compound index on these two columns:
> > - int
> > - varchar(200)
>
> Then you are using a multi-byte character set and/or
> multi-byte collation.

Well, not entirely true. ;-)

Ivan's calculator says, that with your above scenario you are exceeding the
limit, even with a single-byte character set and/or collation.

<firebird_20_plug>
In Firebird 2.0, the limit has been increased and depends on the database
page size.
</firebird_20_plug>



Regards,
Thomas