The following table lists the Oracle Service Cloud data types and their equivalent for ODBC.

Table 1. Oracle Service Cloud Data Types for Local Tables
Oracle Service Cloud Data Type Documented Name ODBC Data Type
BASE_64_BINARY base64binary SQL_LONGVARBINARY(-4)
BOOLEAN boolean SQL_BIT(-7)
DATE date SQL_TYPE_DATE(91)
DATETIME datetime SQL_TYPE_TIMESTAMP(93)
DECIMAL double SQL_DOUBLE(8)
ID ID SQL_BIGINT(-5)
INTEGER int SQL_INTEGER(4)
LONG long SQL_BIGINT(-5)
LONGTEXT longText SQL_LONGVARCHAR(-10)
STRING string SQL_VARCHAR(12)