Unicode default forward data type mappings for Microsoft SQL Server data sources
The following table lists the default forward data type mapping for Microsoft SQL Server data sources when the federated database is a Unicode database.
| UTF-8 | Microsoft SQL Server | |
|---|---|---|
| Data type | Data type | Length |
| CHAR | CHAR | 1 to 254 bytes |
| VARCHAR | CHAR | 255 to 8000 bytes |
| VARCHAR | 1 to 8000 bytes | |
| CLOB | TEXT | - |
| GRAPHIC | NCHAR | 1 to 127 characters |
| VARGRAPHIC | NCHAR | 128 to 16336 characters |
| NVARCHAR | 1 to 16336 characters | |
| DBCLOB | NTEXT | - |