Data Types for Aster

The following table lists the data type support for an Aster database.
The NCHAR, NVARCHAR, and TINYINT data types are not supported for data type definition.
For data source specific information about Aster database data types, see the Aster database documentation.
Data Types for Aster
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.
Last updated: February 23, 2017