|
ODBC Driver for Jira Service Management Supported Data Types - ODBC Driver for Jira Service Management |
|
|
|
ODBC Driver for Jira Service Management Supported Data Types - ODBC Driver for Jira Service Management |
|
The Devart ODBC Driver for Jira Service Management supports all Jira Service Management data types.
The following table describes how the Jira Service Management data types are mapped to the ODBC data types.
| JiraService Data Types | ODBC Data Types |
|---|---|
|
ANYTYPE |
SQL_WVARCHAR |
|
AUTONUMBER |
SQL_WVARCHAR |
|
BINARY |
SQL_LONGVARBINARY |
|
CHECKBOX |
SQL_BIT |
|
COMBOBOX |
SQL_WVARCHAR |
|
DATACATEGORYGROUPREFERENCE |
SQL_VARCHAR |
|
|
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 |