ODBC Driver for Salesforce

Supported Data Types - ODBC Driver for Salesforce



Data Type Mapping

The Devart ODBC Driver for Salesforce supports all Salesforce data types.

The following table describes how the Salesforce data types are mapped to the ODBC 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-2022 Devart. All Rights Reserved. Request Support ODBC Forum Provide Feedback