skip to main content
Supported data types : Marketo data types
 

Try DataDirect Cloud Now

Marketo data types

The following table lists the data types supported by the Marketo data store and shows how the Marketo 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, Marketo uses the following subset but makes available a larger set to support future web service API changes.
Table 8. Marketo data types
Marketo type
ODBC type
JDBC data type
BOOLEAN
SQL_BIT
BIT
CURRENCY
SQL_FLOAT
FLOAT
DATE
SQL_DATE
DATE
DATETIME
SQL_TIMESTAMP
TIMESTAMP
EMAIL
SQL_WVARCHAR or SQL_VARCHAR
VARCHAR
FLOAT
SQL_FLOAT
FLOAT
INTEGER
SQL_INTEGER
INTEGER
PHONE
SQL_WVARCHAR or SQL_VARCHAR
VARCHAR
REFERENCE
SQL_INTEGER
INTEGER
STRING
SQL_WVARCHAR or SQL_VARCHAR
VARCHAR
TEXT
SQL_WVARCHAR or SQL_VARCHAR
VARCHAR
URL
SQL_WVARCHAR or SQL_VARCHAR
VARCHAR
Note: If Marketo returns any other data type, it will be mapped to VARCHAR for JDBC applications and SQL_VARCHAR or SQL_WVARCHAR for ODBC applications..