Salesforce Data Type
|
Web Service API Data Type
|
ODBC Data Type
|
ANYTYPE
|
anytype
|
SQL_WVARCHAR
|
AUTONUMBER
|
string
|
SQL_WVARCHAR
|
BINARY
|
binary
|
SQL_LONGVARBINARY
|
CHECKBOX
|
boolean
|
SQL_BIT
|
COMBOBOX
|
combobox
|
SQL_WVARCHAR
|
CURRENCY
|
currency
|
SQL_DECIMAL
|
DATE
|
date
|
SQL_TYPE_DATE
|
DATETIME
|
datetime
|
SQL_TYPE_TIMESTAMP
|
EMAIL
|
email
|
SQL_WVARCHAR
|
ENCRYPTEDTEXT
|
encryptedtext
|
SQL_WVARCHAR
|
HTML
|
html
|
SQL_WLONGVARCHAR
|
ID
|
id
|
SQL_WVARCHAR
|
INT
|
double
|
SQL_INTEGER
|
LONGTEXTAREA
|
longtextarea
|
SQL_WLONGVARCHAR
|
MULTISELECTPICKLIST
|
multipicklist
|
SQL_WVARCHAR
|
NUMBER
|
double
|
SQL_DOUBLE1
|
PERCENT
|
percent
|
SQL_DECIMAL
|
PHONE
|
phone
|
SQL_WVARCHAR
|
PICKLIST
|
picklist
|
SQL_WVARCHAR
|
REFERENCE
|
reference
|
SQL_WVARCHAR
|
TEXT
|
string
|
SQL_WVARCHAR
|
TEXTAREA
|
textarea
|
SQL_WVARCHAR
|
TIME
|
time
|
SQL_TYPE_TIME
|
URL
|
url
|
SQL_WVARCHAR
|
Salesforce Data Type
|
Web Service API Data Type
|
ODBC Data Type
|
ANYTYPE
|
anytype
|
SQL_WVARCHAR
|
AUTONUMBER
|
string
|
SQL_WVARCHAR
|
BINARY
|
binary
|
SQL_LONGVARBINARY
|
CHECKBOX
|
boolean
|
SQL_BIT
|
COMBOBOX
|
combobox
|
SQL_WVARCHAR
|
CURRENCY
|
currency
|
SQL_DOUBLE
|
DATACATEGORYGROUPREFERENCE
|
DataCategoryGroupReference
|
SQL_WVARCHAR
|
DATE
|
date
|
SQL_TYPE_DATE
|
DATETIME
|
datetime
|
SQL_TYPE_TIMESTAMP
|
EMAIL
|
email
|
SQL_WVARCHAR
|
HTML
|
html
|
SQL_WLONGVARCHAR
|
ID
|
id
|
SQL_WVARCHAR
|
INT
|
double
|
SQL_INTEGER
|
LONGTEXTAREA
|
longtextarea
|
SQL_WLONGVARCHAR
|
MULTISELECTPICKLIST
|
multipicklist
|
SQL_WVARCHAR
|
NUMBER
|
double
|
SQL_DOUBLE1
|
PERCENT
|
percent
|
SQL_DOUBLE
|
PHONE
|
phone
|
SQL_WVARCHAR
|
PICKLIST
|
picklist
|
SQL_WVARCHAR
|
REFERENCE
|
reference
|
SQL_WVARCHAR
|
TEXT
|
string
|
SQL_WVARCHAR
|
TEXTAREA
|
textarea
|
SQL_WVARCHAR
|
TIME
|
time
|
SQL_TYPE_TIME
|
URL
|
url
|
SQL_WVARCHAR
|