The following table lists native data types supported by the driver and how they are mapped to ODBC data types.

Table 1. Salesforce Data Types
Salesforce Data Type ODBC Data Type
ANYTYPE SQL_VARCHAR
AUTONUMBER SQL_VARCHAR
BINARY SQL_LONGVARBINARY
CHECKBOX SQL_BIT
COMBOBOX SQL_VARCHAR
CURRENCY SQL_DECIMAL
CURRENCYDOUBLE SQL_DOUBLE
DATACATEGORYGROUPREFERENCE SQL_VARCHAR
DATE SQL_TYPE_DATE
DATETIME SQL_TYPE_TIMESTAMP
EMAIL SQL_VARCHAR
ENCRYPTEDTEXT SQL_VARCHAR
HTML SQL_LONGVARCHAR
ID SQL_VARCHAR
INT SQL_INTEGER
LOCATION SQL_VARCHAR
LONGTEXTAREA SQL_LONGVARCHAR
MULTISELECTPICKLIST SQL_VARCHAR
NUMBER SQL_DOUBLE
NUMBERDECIMAL SQL_DECIMAL
PERCENT SQL_DECIMAL
PERCENTDOUBLE SQL_DOUBLE
PHONE SQL_VARCHAR
PICKLIST SQL_VARCHAR
REFERENCE SQL_VARCHAR
TEXT SQL_VARCHAR
TEXTAREA SQL_VARCHAR
TIME SQL_TYPE_TIME
UNKNOWN SQL_VARCHAR
URL SQL_VARCHAR