Data Type Mapping
Data Type Mappings
The driver maps types from the data source to the corresponding data type available in the schema. The table below documents these mappings.
| SAP HANA | CData Schema |
| INTEGER | INT |
| VARCHAR | VARCHAR |
| DATE | DATE |
| TIME | TIME |
| SECONDDATE | TIMESTAMP |
| TIMESTAMP | TIMESTAMP |
| TINYINT | TINYINT |
| SMALLINT | SMALLINT |
| BIGINT | BIGINT |
| DECIMAL | DECIMAL |
| SMALLDECIMAL | DECIMAL |
| REAL | FLOAT |
| DOUBLE | DOUBLE |
| FLOAT | FLOAT |
| BOOLEAN | BOOLEAN |
| NVARCHAR | VARCHAR |
| ALPHANUM | VARCHAR |
| SHORTTEXT | VARCHAR |
| VARBINARY | VARBINARY |
| BLOB | BLOB |
| CLOB | VARCHAR |
| NCLOB | VARCHAR |
| TEXT | VARCHAR |
| BINTEXT | VARCHAR |
| ARRAY | VARBINARY |