Feedback
The following table lists the default forward data type mappings for Microsoft SQL Server data sources.
| 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 |