The following table lists native data types supported by the driver and how they are mapped to ODBC data types.
Note: This data type mapping is supported for all SAP ODATA V2 services exposed through the SAP Gateway, including S/4HANA and BW/4HANA.
Table 1. Data Types
Data Type ODBC Data Type
BINARY SQL_VARBINARY
BOOLEAN SQL_BIT
BYTE SQL_SMALLINT
DATETIME SQL_TYPE_TIMESTAMP
DECIMAL SQL_DECIMAL
DOUBLE SQL_DOUBLE
GUID SQL_CHAR
INT16 SQL_SMALLINT
INT32 SQL_INTEGER
INT64 SQL_BIGINT
SBYTE SQL_TINYINT
SINGLE SQL_REAL
STRING SQL_VARCHAR
TIMEOFDAY SQL_TYPE_TIME