The following table lists supported Oracle Marketing Cloud Eloqua data types and their equivalent ODBC data types.

Table 1. Eloqua data types
Eloqua type ODBC type
ARRAY SQL_WVARCHAR(-9) or SQL_WVARCHAR(12)
BOOLEAN SQL_BIT (-7)
DATETIME SQL_TYPE_TIMESTAMP(93)
DECIMAL SQL_DECIMAL(3)
DURATION SQL_WVARCHAR(-9) or SQL_WVARCHAR(12)
INTEGER SQL_INTEGER (-4)
LARGETEXT SQL_WLONGVARCHAR(-10) or SQL_LONGVARCHAR(-1)
LONG BIGINT (-5)
TEXT SQL_WVARCHAR(-9) or SQL_WVARCHAR(12)
URL SQL_WVARCHAR(-9) or SQL_WVARCHAR(12)
Note: Columns that are named as "ID" are mapped to BIGINT.