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)
1	BOOL	One byte integral data type that can contain values 0, 1, or NULL.	1
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)
1	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.