Explore the different datatype to catalog datatype mappings available for the datasource.
-
Default mapping
The tables lists the mapping from datatype to catalog datatype, making data management simpler and more organized.
Table 1. 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 double 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 -
Advanced connectivity bundle mapping
The tables lists the mapping from datatype to catalog datatype using advance connectivity bundle, making data management simpler and more organized. For configuration details, refer Advanced connectivity 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