Default forward data type mappings for Microsoft SQL Server data sources

The following table lists the default forward data type mappings for Microsoft SQL Server data sources.

Note: The remote typenames for Microsoft SQL Server are case sensitive.
Table 1. Microsoft SQL Server default forward data type mappings
Remote Typename Remote Lower Len Remote Upper Len Remote Lower Scale Remote Upper Scale Remote Bit Data Remote Data Operators Federated Typename Federated Length Federated Scale Federated Bit Data
bigint - - - - - - BIGINT - - -
binary 1 254 - - - - CHARACTER - - Y
binary 255 8000 - - - - VARCHAR - - Y
bit - - - - - - SMALLINT 2 - -
char 1 254 - - - - CHAR - - N
char 255 8000 - - - - VARCHAR - - N
datetime - - - - - - TIMESTAMP(6) 10 6 -
datetime2 19 27 0 7 - - TIMESTAMP - - -
decimal 1 31 0 31 - - DECIMAL - - -
decimal 32 38 0 38 - - DOUBLE - - -
float - 8 - - - - DOUBLE 8 - -
float - 4 - - - - REAL 4 - -
image - - - - - - BLOB 2147483647 - Y
int - - - - - - INTEGER 4 - -
money - - - - - - DECIMAL 19 4 -
nchar 1 127 - - - - CHAR - - N
nchar 128 4000 - - - - VARCHAR - - N
numeric 1 31 0 31 - - DECIMAL - - -
numeric 32 38 0 38 - - DOUBLE 8 - -
ntext - - - - - - CLOB 2147483647 - Y
nvarchar 1 4000 - - - - VARCHAR - - N
real - - - - - - REAL 4 - -
smallint - - - - - - SMALLINT 2 - -
smalldatetime - - - - - - TIMESTAMP(6) 10 6 -
smallmoney - - - - - - DECIMAL 10 4 -
SQL_BIGINT* - - - - - - BIGINT - - -
SQL_BINARY* 1 254 - - - - CHARACTER - - Y
SQL_BINARY* 255 8000 - - - - VARCHAR - - Y
SQL_BIT* - - - - - - SMALLINT 2 - -
SQL_CHAR* 1 254 - - - - CHAR - - N
SQL_CHAR* 255 8000 - - - - VARCHAR - - N
SQL_DATE* - - - - - - DATE 4 - -
SQL_DECIMAL* 1 31 0 31 - - DECIMAL - - -
SQL_DECIMAL* 32 38 0 38 - - DOUBLE 8 - -
SQL_DOUBLE* - - - - - - DOUBLE 8 - -
SQL_FLOAT* - - - - - - DOUBLE 8 - -
SQL_GUID* - - - - - - VARCHAR - - Y
SQL_INTEGER* - - - - - - INTEGER 4 - -
SQL_ LONGVARCHAR* - - - - - - CLOB 2147483647 - N
SQL_ LONGVARBINARY* - - - - - - BLOB - - Y
SQL_NUMERIC* 1 31 0 31 - - DECIMAL - - -
SQL_NUMERIC* 32 38 0 38 - - DOUBLE 8 - -
SQL_REAL* - - - - - - REAL 8 - -
SQL_SMALLINT* - - - - - - SMALLINT 2 - -
SQL_TIME* - - - - - - TIME 3 - -
SQL_TIMESTAMP* - - - - - - TIMESTAMP 10 6 -
SQL_TINYINT* - - - - - - SMALLINT 2 - -
SQL_VARBINARY* 1 8000 - - - - VARCHAR - - Y
SQL_VARCHAR* 1 8000 - - - - VARCHAR - - N
SQL_WCHAR* 1 254 - - - - CHARACTER - - N
SQL_WCHAR* 255 8800 - - - - VARCHAR - - N
SQL_WLONGVARCHAR* - 1073741823 - - - - CLOB 2147483647 - N
SQL_WVARCHAR* 1 16336 - - - - VARCHAR - - N
                     
text - - - - - - CLOB - - N
timestamp - - - - - - VARCHAR 8   Y
tinyint - - - - - - SMALLINT 2 - -
uniqueidentifier 1 4000 - - Y - VARCHAR 16 - Y
varbinary 1 8000 - - - - VARCHAR - - Y
varchar 1 8000 - - - - VARCHAR - - N
* You cannot use this data type in the type-mapping-name clause of the CREATE TYPE MAPPING statement.