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 |