The following table describes the mapping between the Salesforce and ODBC data types.
| Salesforce data type | ODBC data type |
|---|---|
ANYTYPE |
SQL_WVARCHAR |
AUTONUMBER |
SQL_WVARCHAR |
BINARY |
SQL_LONGVARBINARY |
CHECKBOX |
SQL_BIT |
COMBOBOX |
SQL_WVARCHAR |
DATACATEGORYGROUPREFERENCE |
SQL_VARCHAR |
EMAIL |
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 |