|
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. | |||