ODBC Driver for Salesforce

Supported Data Types



ODBC Driver for Salesforce supports all the Salesforce data types.

The complete list of Salesforce data types is available in the Salesforce documentation.

Data Type Mapping

The following table describes how ODBC data types are mapped to Salesforce data types.

Salesforce Data Types ODBC Data Types

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

© 2015-2017 Devart. All Rights Reserved. Request Support ODBC Forum Provide Feedback