skip to main content
Supported data types : Oracle Eloqua data types
 

Try DataDirect Cloud Now

Oracle Eloqua data types

The following table lists the data types supported by the Eloqua data store and shows how the Eloqua data types map to the JDBC and ODBC data types that an application will use.
Of the available data types exposed by the web service, as of this writing, Eloqua uses the following subset but makes available a larger set to support future web service API changes.
Table 13. Eloqua data types
Eloqua type
ODBC type
JDBC data type
STRING
SQL_WVARCHAR or SQL_VARCHAR
VARCHAR
BOOLEAN
SQL_BIT
BIT
INT
SQL_INTEGER
INTEGER
DATETIME
SQL_TIMESTAMP
TIMESTAMP
ENUM
SQL_WVARCHAR or SQL_VARCHAR
VARCHAR
LONG
BIGINT
BIGINT
DECIMAL
SQL_NUMERIC
NUMERIC
ANYURI
SQL_WVARCHAR or SQL_VARCHAR
VARCHAR
HTML
SQL_WLONGVARCHAR or SQL_LONGVARCHAR
LONGVARCHAR
Note: Columns that are named as "ID" are mapped to BIGINT. Columns that end with "ID" are mapped to VARCHAR instead of WVARCHAR.