SAP Hana Type |
DTS Type |
bigint |
INT64 |
integer |
INT32 |
smallint |
INT16 |
tinyint |
INT16 |
decimal |
DECIMAL |
dec |
DECIMAL |
smalldecimal |
DECIMAL |
float |
FLOAT |
real |
FLOAT |
double |
DOUBLE |
date |
DATE |
timestamp |
DATE_TIME |
seconddate |
DATE_TIME |
time |
TIME |
char |
STRING |
nchar |
STRING |
varchar |
STRING |
nvarchar |
STRING |
shorttext |
STRING |
alphanum |
STRING |
string |
STRING |
binary |
BINARY |
varbinary |
BINARY |
st_geometry |
DTS_GEOMETRY |
st_point |
DTS_GEOMETRY |
Array Types are fully supported and mapped as arrays of the respective element's DTS type.
Table Types are also fully supported and mapped as DTS objects which reflect the table type's column structure.
Currently Unsupported Native Types:
blob, clob, nclob, text, bintext
See also