Data Types for MDS

The following table lists the data type support for the in-memory database.

Data Types for MDS
Data Type Definition Keyword 2	MDS Data Type	Description	Data Type Returned
BIGINT	BIGINT	64-bit, signed integer.	BIGINT
BINARY(n)	BINARY(n)	Fixed-length binary data.	BINARY(n)
CHAR(n)	CHAR(n)	Fixed-length character string data.	CHAR(n)
DATE	DATE	Date value.	DATE
DECIMAL\|NUMERIC(p,s)	NUMERIC(p,s)	Precision scale numeric.	DECIMAL/NUMERIC(p,s)
DOUBLE	DOUBLE	8-byte IEEE floating-point value. Note: Supports ANSI SQL null values	DOUBLE
FLOAT(p)	DOUBLE	8-byte IEEE floating-point value. Note: Supports ANSI SQL null values	DOUBLE
INTEGER	INTEGER	32-bit, signed integer.	INTEGER
NCHAR(n)	NCHAR(n)	Fixed-length Unicode character string.	NCHAR(n)
NVARCHAR(n)	NVARCHAR(n)	Varying-length Unicode character string.	NVARCHAR(n)
REAL	DOUBLE	8-byte IEEE floating-point value. Note: Supports ANSI SQL null values	DOUBLE
SMALLINT	INTEGER	32-bit, signed integer.	INTEGER
TIME(p)	TIME(p)	Time value.	TIME(p)
TIMESTAMP(p)	TIMESTAMP(p)	Date and time value.	TIMESTAMP(p)
TINYINT	INTEGER	32-bit, signed integer.	INTEGER
1	UBIGINT	64-bit, unsigned integer.	BIGINT
1	UINTEGER	32-bit, unsigned integer.	INTEGER
VARCHAR(n)	VARCHAR(n)	Varying-length character string data.	VARCHAR(n)
VARBINARY(n)	VARBINARY(n)	Varying-length binary data.	VARBINARY(n)
1The MDS SQL data type cannot be defined, and when data is retrieved, the native data type is mapped to a similar data type.
2The CT_PRESERVE= connection argument, which controls how data types are mapped, can affect whether a data type can be defined. The values FORCE (default) and FORCE_COL_SIZE do not affect whether a data type can be defined. The values STRICT and SAFE can result in an error if the requested data type is not native to the data source, or the specified precision or scale is not within the data source range.