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