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 |