Datatype Mapping Between SAP ASE and HANA

When you create proxy tables, SAP ASE datatypes are mapped to corresponding HANA datatypes.

HANAODBC maps these SAP ASE datatypes to HANA datatypes when you use create table to create proxy tables:
SAP ASE Datatype HANA Datatype
tinyint tinyint
smallint smallint
int integer
integer integer
bigint bigint
unsigned smallint integer
unsigned int bigint
unsigned bigint Not supported
numeric (precision, scale) decimal (precision, scale)
decimal (precision, scale) decimal (precision, scale)
float(precision) float(precision)
double (precision) float
real real
smallmoney decimal (10,4)
money decimal (19,4)
smalldatetime timestamp
datetime timestamp
date date
time time
char(n) char(n)
varchar(n) varchar(n)
unichar(n) nchar(n)
univarchar(n) nvarchar(n)
nchar(n) char(n)
nvarchar(n) varchar(n)
text clob
unitext nclob
binary(n) binary(n)
varbinary(n) varbinary(n)
image blob
bit tinyint
bigdatetime timestamp
bigtime Not supported
These datatypes are allowed when you map remote HANA columns to local proxy table columns:
Remote HANA Datatype SAP ASE Datatype
tinyint tinyint
smallint smallint
int integer
integer integer
bigint bigint
decimal(precision, scale) decimal(precision, scale)
real real
double double precision
float(precision) double precision
date date
time time
seconddate datetime
timestamp bigdatetime
varchar(n) varchar(n)
nvarchar(n) univarchar(n)
alphanum(n) univarchar(n)
char(n) char(n)
nchar(n) unichar(n)
varbinary(n) varbinary(n)
clob text
binary (n) binary (n)
blob image
nclob unitext