Firebird数据库版本差别

 http://www.firebirdsql.org/index.php?op=guide&id=techspec

 

Firebird Technical Specifications

Updated 2007-07-16 and subject to review

Database Limits
ItemFirebird 2.xFirebird 1.5.x

Maximum size of databasePractically unlimited using multiple database files (largest known database is over 980 GB)32 TB using multiple files

Maximum size of one database fileMultiple terabytes on most platforms; limited by file systems (4 GB or 2 GB on some platforms)Same

Maximum number of database files64,535Same

Maximum number of tables64,535Same

Maximum size of one table~32 TB~36 GB

Maximum size of external table file2 GBSame

Maximum number of rows per table> 16 Billion (not been measured beyond this)~4 Billion
 NOTE :: 1 Billion is 1024³

Maximum row size65,536 bytes (64 KB)Same

Maximum database page size16 KBSame
 NOTE :: Page size (PAGE_SIZE) can be 1024, 2048, 4096, 8192 or 16384. Size 1024 is not recommended.

Maximum number of columns per tableDepends on data types used. (Example: 16,384 INTEGER (4-byte) values per row.)
NOTE :: 8-byte ID is stored for each BLOB or ARRAY reference; size of BLOB or ARRAY data is not counted in row size.

Maximum number of indexes per table65,535Same

Maximum size (total width) of index key4,096 bytes when page size is 16 KB (limited to 1/4 of database page size)252 bytes
 IMPORTANT :: Limit decreases for character columns when character set is multi-byte; non-binary collation further reduces limit.  

Maximum number of indexes per database4,398,046,511,104Same

Data Type Specifics
NameSizeRange/PrecisionDescription

Varchar(n)n chars1 to 32767 bytesVariable length char or text string. NB, multi-byte character sets reduce number of possible characters proportionately

Smallint16 bits-2^15 to 2^15-1Signed short (word)

Integer32 bits-2^31 to 2^31-1Signed long (longword)

Float32 bits3.4 x 10^-38 to 3.4 x 10^38Accurate to 7 digits

Double Precision64 bits1.7 x 10^-308 to 1.7 x 10^308Accurate to 15 digits

Timestamp64 bits (2 X 32 bits)1 Jan 100 CE to 28 Feb 32768 CEIncludes time and date as two 32-bit structures

Date32 bits1 Jan 100 CE to 28 Feb 32768 CEDate only. Time part is not stored.

Time32 bits0:00 to 23:59.9999 

BLOB<32GB--Stores data of variable indeterminate size

Numeric (precision, scale)Variable (16, 32, or 64 bits)specifies exactly precision digits of precisionExample: Numeric(10,3) holds numbers accurately in the following format: ppppppp.sss

Decimal (precision, scale)Variable (16, 32, or 64 bits)specifies at least precision digits of precisionExample: Decimal(10,3) holds numbers accurately in the following format: ppppppp.sss

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值