Neoview SQL Reference Manual (R2.4)

SMALLINT [SIGNED|UNSIGNED]
specifies an exact numeric column—a two-byte binary integer, SIGNED or UNSIGNED. The
column stores integers in the range unsigned 0 to 65535 or signed -32768 to +32767.
The default is SIGNED.
INT[EGER] [SIGNED|UNSIGNED]
specifies an exact numeric column—a 4-byte binary integer, SIGNED or UNSIGNED. The
column stores integers in the range unsigned 0 to 4294967295 or signed -2147483648 to
[phone].
The default is SIGNED.
LARGEINT
specifies an exact numeric column—an 8-byte signed binary integer. The column stores
integers in the range -2**63 to +2**63 -1 (approximately 9.223 times 10 to the eighteenth
power).
DEC[IMAL] [(precision [,scale])] [SIGNED|UNSIGNED]
specifies an exact numeric column—a decimal number, SIGNED or UNSIGNED,stored as
ASCII characters. precision specifies the total number of digits and cannot exceed 18. If
precision is 10 or more, the value must be SIGNED. The sign is stored as the first bit of the
leftmost byte. scale specifies the number of digits to the right of the decimal point.
The default is DECIMAL (9,0) SIGNED.
FLOAT [( precision )]
specifies an approximate numeric column. The column stores floating-point numbers and
designates from 1 through 54 bits of precision. The range is from +/-
2.2250738585072014e-308 through +/-1.7976931348623157e+308 stored in 8 bytes.
An IEEE FLOAT precision data type is stored as an IEEE DOUBLE, that is, in 8 bytes, with
the specified precision.
The default precision is 54.
REAL
specifies a 4-byte approximate numeric column. The column stores 32-bit floating-point
numbers with 23 bits of binary precision and 8 bits of exponent.
The minimum and maximum range is from +/- 1.17549435e-38 through +/ 3.40282347e+38.
DOUBLE PRECISION
specifies an 8-byte approximate numeric column.
The column stores 64-bit floating-point numbers and designates from 1 through 52 bits of
precision.
An IEEE DOUBLE PRECISION data type is stored in 8 bytes with 52 bits of binary precision
and 11 bits of exponent. The minimum and maximum range is from +/-
2.2250738585072014e-308 through +/-1.7976931348623157e+308.
Data Types 239