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 | datetime |
| Decimal | decimal |
| Document ID | varchar |
| Domain ID | varchar |
| Due Date | datetime |
| 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 | bool |
| URL | varchar |
| UTC Time | varchar |
| Video | varchar |
| Wiki | varchar |
| Workflow | varchar |