| 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 |