Default reverse data type mappings for Microsoft SQL Server data sources
The following table lists the default reverse data type mappings for Microsoft SQL Server data sources.
| Federated Typename | Federated Lower Len | Federated Upper Len | Federated Lower Scale | Federated Upper Scale | Federated Bit Data | Federated Data Operators | Remote Typename | Remote Length | Remote Scale | Remote Bit Data |
|---|---|---|---|---|---|---|---|---|---|---|
| BIGINT | - | - | - | - | - | - | bigint | - | - | - |
| BLOB | - | - | - | - | - | - | image | - | - | - |
| CHARACTER | - | - | - | - | Y | - | binary | - | - | - |
| CHARACTER | - | - | - | - | N | - | char | - | - | - |
| CLOB | - | - | - | - | - | - | text | - | - | - |
| DATE | - | 4 | - | - | - | - | datetime | - | - | - |
| DECIMAL | - | - | - | - | - | - | decimal | - | - | - |
| DOUBLE | - | 8 | - | - | - | - | float | - | - | - |
| INTEGER | - | - | - | - | - | - | int | - | - | - |
| SMALLINT | - | - | - | - | - | - | smallint | - | - | - |
| REAL | - | 4 | - | - | - | - | real | - | - | - |
| TIME | - | 3 | - | - | - | - | datetime | - | - | - |
| TIMESTAMP | - | - | 0 | 3 | - | - | datetime | - | - | - |
| TIMESTAMP | - | - | 4 | 7 | - | - | datetime2 | - | - | - |
| TIMESTAMP | - | - | 8 | 12 | - | - | datetime2 | - | 7 | - |
| VARCHAR | 1 | 8000 | - | - | N | - | varchar | - | - | - |
| VARCHAR | 8001 | 32672 | - | - | N | - | text | - | - | - |
| VARCHAR | 1 | 8000 | - | - | Y | - | varbinary | - | - | - |
| VARCHAR | 8001 | 32672 | - | - | Y | - | image | - | - | - |