Unicode default reverse data type mappings for ODBC data sources
The following table lists the default reverse data type mapping for ODBC data sources when the federated database is a Unicode database.
| UTF-8 | ODBC | |
|---|---|---|
| Data type | Length | Data type |
| CHAR | 1 to 254 bytes | SQL_CHAR |
| VARCHAR | 1 to 32672 bytes | SQL_VARCHAR |
| CLOB | 1 to 2 147 483 647 bytes | SQL_LONGVARCHAR |
| GRAPHIC | 1 to 127 characters | SQL_WCHAR |
| VARGRAPHIC | 1 to 16336 characters | SQL_WVARCHAR |
| DBCLOB | 1 to 1 073 741 823 characters | SQL_WLONGVARCHAR |