Explore the different datatype to catalog datatype mappings available for the datasource.
Advanced connectivity bundle mapping
The mapping from datatype to catalog datatype makes data management simpler and more organized when advanced connector bundle is used. For configuration details, refer Advanced connector bundle.
| Datatype | Catalog datatype |
|---|---|
| Boolean | boolean |
| Unicode string | string |
| Unicode text stream | string |
| bool | boolean |
| byte stream | blob |
| bytes | blob |
| currency | decimal |
| cy | decimal |
| database date | date |
| database time | time |
| database timestamp | datetime |
| date | date |
| dateTime | datetime |
| dbDate | date |
| dbTime | time |
| dbTimeStamp | datetime |
| decimal | decimal |
| double-precision float | double |
| eight-byte signed integer | integer |
| eight-byte unsigned integer | integer |
| file timestamp | datetime |
| float | float |
| four-byte signed integer | integer |
| four-byte unsigned integer | integer |
| guid | string |
| i1 | string |
| i2 | string |
| i4 | string |
| i8 | string |
| image | blob |
| nText | string |
| numeric | decimal |
| r4 | string |
| r8 | string |
| single-byte signed integer | integer |
| single-byte unsigned integer | integer |
| str | string |
| string | string |
| text | string |
| text stream | string |
| two-byte signed integer | integer |
| two-byte unsigned integer | integer |
| ui1 | string |
| ui2 | string |
| ui4 | string |
| ui8 | string |
| unique identifier | string |
| wstr | string |