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
2	ALPHANUM(n)	Varying-length character string.	NVARCHAR(n)
BIGINT	BIGINT	64-bit integer.	BIGINT
BINARY(n)	BINARY(n)	Fixed-length binary data.	BINARY(n)
2	BLOB	Varying-length binary large object string.	2
CHAR(n)	CHAR(n)	Varying-length character string.	CHAR(n)
2	CLOB	Varying-length character large object string.	2
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)
2	NCLOB	Fixed-length character large object string.	2
NVARCHAR(n)	NVARCHAR(n)	Varying-length Unicode character large object string.	NVARCHAR(n)
REAL	REAL	Floating-point number.	REAL
2	SECONDATE	Date and time value.	2
2	SHORTTEXT(n)	Varying-length character string.	NVARCHAR(n)
2	SMALLDECIMAL(p,s)	Floating-point decimal number.	DECIMAL(p,s)
SMALLINT	SMALLINT	16-bit integer.	SMALLINT
2	TEXT	Varying-length Unicode character large object string.	2
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.