ODBC Driver for Salesforce Marketing Cloud Supported Data Types - ODBC Driver for Salesforce Marketing Cloud |
The Devart ODBC Driver for Salesforce MC supports all Salesforce MC data types.
The following table describes how the Salesforce MC data types are mapped to the ODBC data types.
Salesforce Marketing Cloud Data Types | ODBC Data Types |
---|---|
BINARY |
SQL_VARBINARY |
STRING |
SQL_VARCHAR |
SQL_LONGVARCHAR |
|
SQL_WVARCHAR |
|
SQL_WLONGVARCHAR |
|
BOOLEAN |
SQL_BIT |
BYTE |
SQL_TINYINT |
INTEGER |
SQL_INTEGER |
SQL_SMALLINT |
|
DOUBLE |
SQL_FLOAT |
SQL_DOUBLE |
|
TIME |
SQL_TYPE_TIME |
DATE |
SQL_TYPE_DATE |
DATETIME |
SQL_TYPE_TIMESTAMP |