JDBC Driver for SAP HANA

Build 22.0.8396

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.

INTEGER INT
VARCHAR VARCHAR
DATE DATE
TIME TIME
SECONDDATE SECONDDATE
TIMESTAMP TIMESTAMP
TINYINT TINYINT
SMALLINT SMALLINT
BIGINT BIGINT
DECIMAL DECIMAL
SMALLDECIMAL SMALLDECIMAL
REAL REAL
DOUBLE FLOAT
FLOAT REAL
BOOLEAN BIT
NVARCHAR NVARCHAR
ALPHANUM ALPHANUM
SHORTTEXT SHORTTEXT
VARBINARY VARBINARY
BLOB BLOB
CLOB CLOB
NCLOB NCLOB
TEXT TEXT
BINTEXT BINTEXT
ARRAY ARRAY

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 22.0.8396