|
ODBC Driver for Salesforce Marketing Cloud Supported Data Types - ODBC Driver for Salesforce Marketing Cloud |
|
|
|
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 |