Data Types for SAP HANA

The following table lists the data type support for an SAP HANA database.
For data source specific information about the SAP HANA data types, see the SAP HANA database documentation.
Data Types for SAP HANA
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.
Last updated: February 23, 2017