Notation | Type | Range |
---|---|---|
char(1) - char(n) | character | A string of 1 to n characters; n represents the lesser of the maximum configured row size and 32,000. |
c1 - cn | character | A string of 1 to n characters; n represents the lesser of the maximum configured row size and 32,000. |
varchar(1) - varchar(n) | character | A string of 1 to n characters; n represents the lesser of the maximum configured row size and 32,000. |
text(1) - text(n) | character | A string of 1 to n characters; n represents the lesser of the maximum configured row size and 32,000. |
i1 | 1-byte integer | -128 to +127 |
i2 | 2-byte integer | -32,768 to +32,767 |
i4 | 4-byte integer | -2,147,483,648 to +2,147,483,647 |
float4 | 4-byte floating | -1.0e+38 to +1.0e+38 (7 digit precision) |
float | 8-byte floating | -1.0e+38 to +1.0e+38 (16 digit precision) |
date | date (12 bytes) | 1-jan-0001 to 30-dec-9999 (for absolute dates) and -9999 years to 9999 years (for time intervals) |
money | money (8 bytes) | $-999,999,999,999.99 to $999,999,999,999.99 |
byte | binary | Fixed length binary data, 1 to maximum configured row size. |
byte varying | binary | Variable length binary data, 1 to maximum configured row size. |