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
UBIGINT
64-bit, unsigned integer.
BIGINT
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.
Last updated: February 23, 2017