Database Statistics (Upper Limits)

Maximum size of database: 32TB using multiple files; largest recorded InterBase database in production is over 200GB

Maximum size of one file: 4GB on most platforms; 2GB on some platforms

Maximum number of tables: 64K Tables

Maximum size of one table: 32TB

Maximum number of rows per table: 4G Rows

Maximum row size: 64KB

Maximum number of columns per table: Depends on the datatypes you use. (Example: 16,384 INTEGER (4 byte) values per row.)

Maximum number of indexes per table: 64K indexes

Maximum number of indexes per database: 4G indexes

InterBase Datatype Specifics

Name	Size	Range/Precision	Description
Varchar(n)	n chars	1 to 32767 bytes	Variable length char or text string
Smallint	16 bits	-2^15 to 2^15-1	Signed short (word)
Integer	32 bits	-2^31 to 2^31-1	Signed long (longword)
Float	32 bits	3.4 x 10^-38 to 3.4 x 10^38	7 digit precision
Double Precision	64 bits	1.7 x 10^-308 to 1.7 x 10^308	15 digit precision
*Timestamp	64 bits	1 Jan 100 a.d. to 28 Feb 32768 a.d.	Includes time and date
**Date	32 bits	1 Jan 100 a.d. to 29 Feb 32768 a.d.
*Time	32 bits	0:00 AM to 23:59.9999 PM
Blob	<32GB		Stores data of variable indeterminate size
***Numeric (precision, scale)	Variable (16, 32, or 64)	specifies exactly precision digits of precision	Example: Numeric(10,3) holds numbers accurately in the following format: ppppppp.sss
***Decimal (precision, scale)	Variable (16, 32, or 64)	specifies at least precision digits of precision	Example: Decimal(10,3) holds numbers accurately in the following format: ppppppp.sss

* New to InterBase 6.0
** Date datatype holds both date and time information in versions prior to 6.0
*** precisions greater than 9 are stored as exact numerics in 6.0 and non-exact double precision in previous versions