|
SQL Type
|
Description
|
|
BINARY
|
Binary stream of fixed length n (1 <= 254).
|
|
BIT
|
An integer data type that can take a value of 0 or 1.
|
|
CHAR(n)
|
Character string of fixed string length n (1 <= 254).
|
|
DATE
|
Date data.
|
|
DOUBLE PRECISION
|
Signed, approximate, numeric value with a mantissa precision 15 (zero or absolute value 10-38 to 1038).
|
|
FLOAT
|
Signed, approximate, numeric value with a mantissa precision 15 (zero or absolute value 10-38 to 1038).
|
|
INTEGER
|
Exact numeric value with precision 10 and scale 0. (signed: -231 <=n <=231-1, unsigned: 0<=n <=232-1).
|
|
LONGVARBINARY
|
Variable-length binary data; length is data source specific. This type is used for BLOB.
|
|
LONGVARCHAR
|
Variable-length character data with maximum string length data source dependent, with maximum length 2 GB
|
|
NUMERIC(p, s)
|
Signed, exact, numeric value with a precision p and scale s (1<=p<=40, 0<=s<=p)
|
|
REAL
|
Signed, approximate, numeric value with a mantissa precision 7 (zero or absolute value 10-38 to 1038)
|
|
SMALLINT
|
Exact numeric value with precision 5 and scale 0. (signed: -32,768 <=n <=32,767, unsigned:0<=n<=65,535).
|
|
TIME
|
Time data.
|
|
TIMESTAMP
|
Date/time data.
|
|
TINYINT
|
An integer value in the range of 0 to 255.
|
|
VARBINARY
|
Variable-length binary data; this type is deal for binary data of 4 KB or less.
|
|
VARCHAR(n)
|
Variable-length character string with a maximum string length data source dependent; this type is ideal for strings of 4 KB or less
|
|
WCHAR(n)1
|
Unicode string of fixed string length n (1 ≤ n ≤ 254).
|
|
WLONGVARCHAR*
|
Variable-length Unicode character data with maximum string length data source dependent, with maximum length 2 GB.
|
|
WVARCHAR(n)*
|
Variable-length Unicode string with a maximum string length data source dependent.
|