Neoview Database Administrator's Guide (R2.2)

A Data Types
For details about SQL components, see the Neoview SQL Reference Manual.
Your Neoview platform supports these data types:
Size or Range (1)DescriptionSQL DesignationType
1 to 4036 characters (2)Fixed-length character dataCHAR[ACTER]Fixed-length
character
1 to 4036 characters (2)Fixed-length character dataPIC[TURE]
1 to 4036 characters (3)Fixed-length character data
in predefined national
character set
NCHAR
1 to 4036 characters (3)Fixed-length character data
in predefined national
character set
NATIONAL CHAR[ACTER]
1 to 4028 characters (4)Variable-length ASCII
character string
VARCHARVariable-length
character
1 to 4028 characters (4)Variable-length ASCII
character string
CHAR[ACTER] VARYING
1 to 4028 characters (5)Variable-length ASCII
character string
NCHAR VARYING
1 to 4028 characters (5)Variable-length ASCII
character string
NATIONAL CHAR[ACTER]
VARYING
1 to 18 digits; stored:
1 to 4 digits in 2 bytes
5 to 9 digits in 4 bytes
10 to 18 digits in 8 bytes
Binary number with optional
scale; signed or unsigned for
1 to 9 digits; sign required for
10 or more digits
NUMERIC (1,scale) to
NUMERIC (18,scale)
Numeric
1 to 18 digits; stored as NUMERICBinary number; same as
NUMERIC
PIC[TURE] S9V9 COMP to
PIC[TURE] S9(18) COMP
0 to 65535 unsigned, -32768 to
+32767 signed; stored in 2 bytes
Binary integer; signed or
unsigned
SMALLINT
0 to 4294967295 unsigned,
-2147483648 to [phone] signed;
stored in 4 bytes
Binary integer; signed or
unsigned
INTEGER
-2**63 to +2**63-; stored in 8 bytesBinary integer; signed onlyLARGEINT
+/- 2.2250738585072014e-308
through
+/-1.7976931348623157e+308; stored
in 8 bytes
Floating point number;
precision designates from 1
through 52 bits of precision
FLOAT[(precision)]Floating point
number
+/- 1.17549435e-38 through +/
3.40282347e+38; stored in 4 bytes
Floating point number (32
bits)
REAL
+/- 2.2250738585072014e-308
through
+/-1.7976931348623157e+308; stored
in 8 byte
Floating-point numbers (64
bits) with 1 through 52 bits
of precision (52 bits of binary
precision and 11 bits of
exponent)
DOUBLE PRECISION
139