skip to main content
Supported data types : Oracle Marketing Cloud data types
 

Try DataDirect Cloud Now

Oracle Marketing Cloud data types

The following table lists the data types supported by the Oracle Marketing Cloud data store and shows how the Oracle Marketing Cloud 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, Oracle Marketing Cloud uses the following subset but makes available a larger set to support future web service API changes.
Table 14. Oracle Marketing Cloud data types
Oracle Marketing Cloud type
ODBC type
JDBC data type
STRING
SQL_WVARCHAR (-9) or SQL_VARCHAR (12)
VARCHAR
BOOLEAN
SQL_BIT (-7)
BIT
INT
SQL_INTEGER (-4)
INTEGER
DATETIME
SQL_TYPE_TIMESTAMP (93)
TIMESTAMP
ENUM
SQL_WVARCHAR (-9) or SQL_VARCHAR (12)
VARCHAR
LONG
BIGINT (-5)
BIGINT
DECIMAL
SQL_NUMERIC (-2)
NUMERIC
ANYURI
SQL_WVARCHAR (-9) or SQL_VARCHAR (12)
VARCHAR
HTML
SQL_WLONGVARCHAR (-10) or SQL_LONGVARCHAR (-1)
LONGVARCHAR
Note: Columns that are named as "ID" are mapped to BIGINT.