Data Type Mapping
Data Type Mappings
The driver maps types from the data source to the corresponding data type available in the schema. The table below documents these mappings.
ServiceNow Data Type | CData Schema Data Type |
Sys ID (GUID) | VARCHAR |
Audio | VARCHAR |
Calendar Date/Time | TIMESTAMP |
Choice | VARCHAR |
Color | VARCHAR |
Conditions | VARCHAR |
Condition String | VARCHAR |
Currency | DECIMAL |
Data Structure | VARCHAR |
Date | DATE |
Date/Time | TIMESTAMP |
Decimal | DECIMAL |
Document ID | VARCHAR |
Domain ID | VARCHAR |
Due Date | TIMESTAMP |
Duration | BIGINT |
Field Name | VARCHAR |
File Attachment | VARCHAR |
Floating Point Number | REAL |
FX Currency | VARCHAR |
HTML | VARCHAR |
Icon | VARCHAR |
Image | VARCHAR |
Integer | INT |
IP Address (Validated IPv4,IPv6) | VARCHAR |
Journal | VARCHAR |
Journal Input | VARCHAR |
Journal List | VARCHAR |
List | VARCHAR |
Long | BIGINT |
Name Value Pairs | VARCHAR |
NDS Icon | VARCHAR |
Password (1 Way Encrypted) | VARCHAR |
Password (2 Way Encrypted) | VARCHAR |
Percent Complete | DECIMAL |
Phone Number (E164) | VARCHAR |
Price | DECIMAL |
Script | VARCHAR |
Script (Plain) | VARCHAR |
String | VARCHAR |
String (Full UTF-8) | VARCHAR |
Table Name | VARCHAR |
Time | TIME |
Translated HTML | VARCHAR |
Translated Text | VARCHAR |
True/False | BIT |
URL | VARCHAR |
UTC Time | VARCHAR |
Video | VARCHAR |
Wiki | VARCHAR |
Workflow | VARCHAR |