skip to main content
Querying data stores with SQL : Supported data types : Microsoft Dynamics CRM Online data types
  

Try Now

Microsoft Dynamics CRM Online data types

In communication between your application and the data store, data is mapped several times to the type appropriate for sending and receiving components. The following Microsoft Dynamics CRM Online attribute types are supported.
Table 158. Supported data types
Data Store data type
Intermediary data type
JDBC data type
ODBC data type
BIGINT
long
BIGINT
SQL_BIGINT
BOOLEAN
boolean
BOOLEAN
SQL_BIT
CUSTOMER
string
CHAR
SQL_CHAR or SQL_WCHAR 1
DATETIME
datetime
TIMESTAMP
SQL_TYPE_TIMESTAMP
DECIMAL
decimal
DECIMAL
SQL_DECIMAL
DOUBLE
double
DOUBLE
SQL_DOUBLE
INTEGER
int
INTEGER
SQL_INTEGER
LOOKUP
string
CHAR
SQL_CHAR or SQL_WCHARSQL_WCHAR 2
MANAGEDPROPERTY
boolean
BOOLEAN
SQL_BIT
MEMO
string
LONGVARCHAR
SQL_LONGVARCHAR or SQL_WLONGWVARCHAR 3
MONEY
decimal
DECIMAL
SQL_DECIMAL
OWNER
string
CHAR
SQL_CHAR or SQL_WCHAR 4
PICKLIST
int
INTEGER
SQL_INTEGER
STATE
int
INTEGER
SQL_INTEGER
STATUS
int
INTEGER
SQL_INTEGER
STRING
string
VARCHAR
SQL_VARCHAR or SQL_WVARCHAR 5
UNIQUEIDENTIFIER
string
CHAR
SQL_CHAR or SQL_WCHAR 6
VIRTUAL
string
VARCHAR
SQL_VARCHAR or SQL_WVARCHAR 7
1 The connectivity service returns the WCHAR types when the Hybrid Data Pipeline ODBC driver's connection option EnableWCharSupport is set to 1.

2 The connectivity service returns the WCHAR types when the Hybrid Data Pipeline ODBC driver's connection option EnableWCharSupport is set to 1.

3 The connectivity service returns the WVARCHAR types when the Hybrid Data Pipeline ODBC driver's connection option EnableWCharSupport is set to 1.

4 The connectivity service returns the WCHAR types when the Hybrid Data Pipeline ODBC driver's connection option EnableWCharSupport is set to 1.

5 The connectivity service returns the WVARCHAR types when the Hybrid Data Pipeline ODBC driver's connection option EnableWCharSupport is set to 1.

6 The connectivity service returns the WCHAR types when the Hybrid Data Pipeline ODBC driver's connection option EnableWCharSupport is set to 1.

7 The connectivity service returns the WVARCHAR types when the Hybrid Data Pipeline ODBC driver's connection option EnableWCharSupport is set to 1.

1. The driver returns the WCHAR types when the Hybrid Data Pipeline ODBC driver's connection option EnableWCharSupport is set to 1.
2. The driver returns the WVARCHAR types when the Hybrid Data Pipeline ODBC driver's connection option EnableWCharSupport is set to 1.