프로그래밍 노트

Firebird 데이터 베이스의 Data(Column, field) Type 본문

데이터베이스/Firebird

Firebird 데이터 베이스의 Data(Column, field) Type

띠리 2008. 11. 28. 10:31
Data Type Specifics
Name Size Range/Precision Description

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

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 Accurate to 7 digits

Double Precision 64 bits 1.7 x 10^-308 to 1.7 x 10^308 Accurate to 15 digits

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

Date 32 bits 1 Jan 100 CE to 28 Feb 32768 CE Date only. Time part is not stored.

Time 32 bits 0: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 precision Example: 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 precision Example: Decimal(10,3) holds numbers accurately in the following format: ppppppp.sss



원문
Firebird Novice's Guide
Comments