The Devart ODBC Driver for Marketo supports all Marketo data types.
The following table describes how the Marketo data types are mapped to the ODBC data types.
| Marketo Data Types | ODBC Data Types |
|---|---|
|
ANYTYPE |
SQL_WVARCHAR |
|
AUTONUMBER |
SQL_WVARCHAR |
|
BINARY |
SQL_LONGVARBINARY |
|
CHECKBOX |
SQL_BIT |
|
COMBOBOX |
SQL_WVARCHAR |
|
DATACATEGORYGROUPREFERENCE |
SQL_VARCHAR |
|
|
SQL_WVARCHAR |
|
ENCRYPTEDTEXT |
SQL_WVARCHAR |
|
HTML |
SQL_WLONGVARCHAR |
|
ID |
SQL_WVARCHAR |
|
INT |
SQL_INTEGER |
|
LONGTEXTAREA |
SQL_WLONGVARCHAR |
|
MULTISELECTPICKLIST |
SQL_WVARCHAR |
|
NUMBER |
SQL_DOUBLE |
|
PHONE |
SQL_WVARCHAR |
|
PICKLIST |
SQL_WVARCHAR |
|
REFERENCE |
SQL_WVARCHAR |
|
TEXTAREA |
SQL_WVARCHAR |
|
TIME |
SQL_TYPE_TIME |
|
URL |
SQL_WVARCHAR |