Data types
- Last Updated: May 13, 2025
- 1 minute read
- DataDirect Connectors
- JDBC
- SAP HANA 6.0
- Documentation
The following table lists the data types supported by the driver and describes how they are mapped to JDBC data types. See "getTypeInfo()" for getTypeInfo() results of data types supported by the driver.
Note: The LOB data types only support SELECT
operations.
| SAP HANA Data Type | JDBC Data Type |
|---|---|
| Alphanum | NVARCHAR |
| Bigint | BIGINT |
| Binary | BINARY |
| Bintext | NCLOB |
| Blob | BLOB |
| Boolean | BOOLEAN |
| Char | CHAR |
| Clob | CLOB |
| Date | DATE |
| Decimal | DECIMAL |
| Double | DOUBLE |
| Integer | INTEGER |
| Nchar | NCHAR |
| Nclob | NCLOB |
| Nvarchar | NVARCHAR |
| Real | REAL |
| Seconddate | TIMESTAMP |
| Shorttext | NVARCHAR |
| Smalldecimal | DECIMAL |
| Smallint | SMALLINT |
| Text | NCLOB |
| Time | TIME |
| Timestamp | TIMESTAMP |
| Tinyint | TINYINT |
| Varbinary | VARBINARY |
| Varchar | VARCHAR |