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

Give Ivan's index calculator a try:
http://www.volny.cz/iprenosil/interbase/ip_ib_indexcalculator.htm



Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com