Data Types

The Simba Salesforce ODBC Connector supports many common data formats, converting between Salesforce data types and SQL data types.

Some Salesforce data may be returned differently depending on how the connector is configured:

  • If the Use SQL_WVARCHAR instead of SQL_VARCHAR option (the UseWVarChar property) is enabled, then data types that are normally returned as SQL_VARCHAR are returned as SQL_WVARCHAR instead. For more information, see Use SQL_WVARCHAR instead of SQL_VARCHAR.
  • If the Use SQL_NUMERIC For Result Set Columns Of Type SQL_DOUBLE option (the UseNumeric property) is enabled, then data types that are normally returned as SQL_DOUBLE are returned as SQL_NUMERIC instead. For more information, see Use SQL_NUMERIC for Result Set Columns of Type SQL_DOUBLE.
  • When the Use Analytic API For Executing Reports option (the UseAnalyticAPI property) is disabled, timestamps are returned in the time zone of your locale. Otherwise, timestamps are returned in UTC time. For more information, see Use Analytic API For Executing Reports.

The following table lists the supported data type mappings.

Salesforce Type SQL Type

AnyType

SQL_VARCHAR or SQL_WVARCHAR

Base64

SQL_LONGVARBINARY

Boolean

SQL_BIT

Combobox

SQL_VARCHAR or SQL_WVARCHAR

Currency

SQL_NUMERIC or SQL_DOUBLE

DataCategoryGroupReference

SQL_VARCHAR or SQL_WVARCHAR

Date

SQL_TYPE_DATE

Note:

  • In CSV reports, Date data is returned as a preformatted string.
  • In versions of the ODBC API earlier than 3.0, this data type is called SQL_DATE.

DateTime

SQL_TYPE_TIMESTAMP

Note:

  • In CSV reports, DateTime data is returned as a preformatted string.
  • In versions of the ODBC API earlier than 3.0, this data type is called SQL_TIMESTAMP.

Double

SQL_NUMERIC or SQL_DOUBLE

Email

SQL_VARCHAR or SQL_WVARCHAR

Id

SQL_VARCHAR or SQL_WVARCHAR

Int

SQL_INTEGER

JunctionIdListNames

SQL_VARCHAR or SQL_WVARCHAR

MultiPicklist

SQL_VARCHAR or SQL_WVARCHAR

Percent

SQL_NUMERIC or SQL_DOUBLE

Phone

SQL_VARCHAR or SQL_WVARCHAR

Picklist

SQL_VARCHAR or SQL_WVARCHAR

Reference

SQL_VARCHAR or SQL_WVARCHAR

String

SQL_VARCHAR or SQL_WVARCHAR

TextArea

SQL_VARCHAR or SQL_WVARCHAR

Time

SQL_TYPE_TIME

Note:

  • In CSV reports, Time data is returned as a preformatted string.
  • In versions of the ODBC API earlier than 3.0, this data type is called SQL_TIME.

URL

SQL_VARCHAR or SQL_WVARCHAR

Note:

The Byte, Calculated, and MasterRecordId data types are not supported.

Related topics