|
Data Type Definition
Keyword 1
|
SAP HANA Data Type
|
Description
|
Data Type Returned
|
|---|---|---|---|
|
ALPHANUM(n)
|
Varying-length character
string.
|
NVARCHAR(n)
|
|
|
BIGINT
|
BIGINT
|
64-bit integer.
|
BIGINT
|
|
BINARY(n)
|
BINARY(n)
|
Fixed-length binary
data.
|
BINARY(n)
|
|
BLOB
|
Varying-length binary
large object string.
|
||
|
CHAR(n)
|
CHAR(n)
|
Varying-length character
string.
|
CHAR(n)
|
|
CLOB
|
Varying-length character
large object string.
|
||
|
DATE
|
DATE
|
Year, month, and day
values.
|
DATE
|
|
DECIMAL|NUMERIC(
p,s)
|
DECIMAL(p,s)
|
Signed, exact, fixed-point
decimal number.
|
DECIMAL(p,s)
|
|
DOUBLE
|
DOUBLE
|
Double-precision floating-point
number.
|
DOUBLE
|
|
FLOAT(p)
|
FLOAT(n)
|
Floating-point number.
|
FLOAT(p)
|
|
INTEGER
|
INTEGER
|
32-bit integer.
|
INTEGER
|
|
NCHAR(n)
|
NCHAR(n)
|
Fixed-length Unicode
character string.
|
NCHAR(n)
|
|
NCLOB
|
Fixed-length character
large object string.
|
||
|
NVARCHAR(n)
|
NVARCHAR(n)
|
Varying-length Unicode
character large object string.
|
NVARCHAR(n)
|
|
REAL
|
REAL
|
Floating-point number.
|
REAL
|
|
SECONDATE
|
Date and time value.
|
||
|
SHORTTEXT(n)
|
Varying-length character
string.
|
NVARCHAR(n)
|
|
|
SMALLDECIMAL(p,s)
|
Floating-point decimal
number.
|
DECIMAL(p,s)
|
|
|
SMALLINT
|
SMALLINT
|
16-bit integer.
|
SMALLINT
|
|
TEXT
|
Varying-length Unicode
character large object string.
|
||
|
TIME(p)
|
TIME(p)
|
Time value.
|
TIME(p)
|
|
TIMESTAMP(p)
|
TIMESTAMP(p)
|
Date and time value.
|
TIMESTAMP(
p)
|
|
TINYINT
|
TINYINT
|
Unsigned 8-bit integer.
|
TINYINT
|
|
VARBINARY(n)
|
VARBINARY(n)
|
Varying-length binary
string.
|
VARBINARY(n)
|
|
VARCHAR(n)
|
VARCHAR(n)
|
Varying-length character
string.
|
VARCHAR(n)
|
| 1The 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. | |||
| 2The SAP HANA data type cannot be defined, and when data is retrieved, the native data type is mapped to a similar data type. | |||