Unicode default reverse data type mappings for Microsoft SQL Server data sources
The following table lists the default reverse data type mapping for Microsoft SQL Server data sources when the federated database is a Unicode database.
| UTF-8 | Microsoft SQL Server | |
|---|---|---|
| Data type | Length | Data type |
| CHAR | 1 to 254 bytes | CHAR |
| VARCHAR | 1 to 32672 bytes | VARCHAR |
| CLOB | 1 to 2 147 483 647 bytes | TEXT |
| GRAPHIC | 1 to 127 characters | NCHAR |
| VARGRAPHIC | 1 to 16336 characters | NVARCHAR |
| DBCLOB | 1 to 1 073 741 823 characters | NTEXT |