Maximum values for data types

Data type	Range of values
Alphanumeric and national data types (length in digits)
CHAR	1 <= length <= 256
NCHAR	1 <= length <= 128
VARCHAR	1 <= length <= 32,000
NVARCHAR	1 <= length <= 16,000
Numeric data types (Range of values)
SMALLINT	-215 <= value <= 215-1
INTEGER	-231 <= value <= 231-1
NUMERIC	0 or 10--scale <= value <= 10precision-scale - 10--scale
DECIMAL	0 or 10--scale <= value <= 10precision-scale - 10--scale
REAL (21 binary digits)	0 or 5,4E-79 <= value <= 7,2E75
DOUBLE PRECISION (53 binary digits)	0 or 5,4E-79 <= value <= 7,2E75
FLOAT (21/53 binary digits)	0 or 5,4E-79 <= value <= 7,2E75
Time data types (Range of values)
DATE	0001-01-01 <= date <= 9999-12-31
TIME	00:00:00.000 <= time <= 23:59:61.999
TIMESTAMP	0001-01-01 <= date <= 9999-12-31 and 00:00:00.000 <= time <= 23:59:61.999

Table 82: Maximum values for data types