Hi Alex,

> I've heard that FB 2.5 supports 32K and 64K pages. Is this true? What page
> sizes does FB 2.1.x support?

It isn't true. The max. page size in FB 2.5 remains 16K.

> A somewhat related question is how large should the page size be to allow me
> to index varchar(2048) column with UTF8 character set?

You won't be able to index that. The formula for the max. index key size is:

(Page Size / 4) - 4


There is also Ivan's key size calculator you can play around with:
http://www.volny.cz/iprenosil/interbase/ip_ib_indexcalculator.htm



--
With regards,

Thomas Steinmaurer
Upscene Productions
http://www.upscene.com
http://blog.upscene.com/thomas/

Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server
and NexusDB!