Explore the datatype to catalog datatype mappings available for the datasource.
The tables lists the mapping from datatype to catalog datatype using advance connector bundle, making data management simpler and more organized. For configuration details, refer Advanced connector bundle.
| Datatype | Catalog datatype |
|---|---|
| bigint | integer |
| bigint identity | integer |
| binary | blob |
| bit | boolean |
| char | string |
| date | date |
| datetime | datetime |
| datetime2 | datetime |
| datetimeoffset | datetime |
| decimal | decimal |
| decimal() identity | decimal |
| float | decimal |
| image | blob |
| int | integer |
| int identity | integer |
| money | decimal |
| nchar | string |
| ntext | string |
| numeric | decimal |
| numeric() identity | decimal |
| nvarchar | string |
| nvarchar(max) | string |
| real | decimal |
| smalldatetime | datetime |
| smallint | integer |
| smallint identity | integer |
| smallmoney | decimal |
| sql_variant | string |
| sysname | string |
| text | string |
| time | time |
| timestamp | blob |
| tinyint | integer |
| tinyint identity | integer |
| uniqueidentifier | string |
| varbinary | blob |
| varbinary(max) | blob |
| varchar | string |
| varchar(max) | string |
| xml | string |
| geography | GEOGRAPHY |
| geometry | GEOMETRY |
| hierarcyid | string |
| character varying | string |
| char_varying | string |
| dec | decimal |
| rowversion | datetime |
| NATIONAL CHAR | string |
| NATIONAL CHAR VARYING | string |
| NATIONAL CHARACTER | string |
| NATIONAL CHARACTER VARYING | string |
| NATIONAL TEXT | string |
| double precision | decimal |