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

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