|
Data Type Definition
Keyword
|
Aster Data Type
|
Description
|
Data Type Returned
|
|---|---|---|---|
|
BIGINT
|
BIGINT
|
Large signed, exact
whole number.
|
BIGINT
|
|
BINARY(n)
|
BYTEA
|
Varying-length binary
string.
|
BINARY(n)
|
|
BOOL
|
One byte integral data
type that can contain values 0, 1, or NULL.
|
||
|
CHAR(n)
|
CHAR(n)
|
Fixed-length character
string.
|
CHAR(n)
|
|
DATE
|
DATE
|
Date values.
|
DATE
|
|
DECIMAL|NUMERIC(p,s)
|
NUMERIC(p,s)
|
Signed, fixed-point
decimal number.
|
DECIMAL|NUMERIC(p,s)
|
|
DOUBLE
|
FLOAT(p)
|
Signed, double precision,
floating-point number.
|
DOUBLE
|
|
FLOAT(p)
|
FLOAT(p)
|
Signed, double precision,
floating-point number.
|
FLOAT(p)
|
|
INTEGER
|
INTEGER
|
Regular signed, exact
whole number.
|
INTEGER
|
|
REAL
|
REAL
|
Signed, single precision,
floating-point number.
|
REAL
|
|
SMALLINT
|
SMALLINT
|
Small signed, exact
whole number.
|
SMALLINT
|
|
TIME(p)
|
TIME(p)
|
Time value.
|
TIME(p)
|
|
TIMESTAMP(p)
|
TIMESTAMP(p)
|
Date and time value.
|
TIMESTAMP(p)
|
|
VARBINARY(n)
|
BYTEA
|
Varying-length binary
string.
|
VARBINARY(n)
|
|
TEXT
|
Varying-length large
character string.
|
VARCHAR(n)
|
|
|
VARCHAR(n)
|
VARCHAR(n)
|
Varying-length character
string.
|
VARCHAR(n)
|
| 1The Aster data type cannot be defined, and when data is retrieved, the native data type is mapped to a similar data type. | |||