Default reverse data type mappings for ODBC data sources
The following table lists the default reverse data type mappings for ODBC 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 | - | - | - | - | - | - | SQL_BIGINT | - | - | - |
| BLOB | - | - | - | - | - | - | SQL_LONGVARBINARY | - | - | - |
| BOOLEAN1 | - | - | - | - | - | - | SQL_BIT1 | - | - | - |
| CHAR | - | - | - | - | Y | - | SQL_BINARY | - | - | - |
| - | - | - | - | N | - | SQL_CHAR | - | - | - | |
| CLOB | - | - | - | - | - | - | SQL_LONGVARCHAR | - | - | - |
| DATE | - | 4 | - | - | - | - | SQL_TYPE_DATE | - | - | - |
| DBCLOB | - | - | - | - | - | - | SQL_WLONGVARCHAR | - | - | - |
| DECIMAL | - | - | - | - | - | - | SQL_DECIMAL | - | - | - |
| DOUBLE | - | 8 | - | - | - | - | SQL_DOUBLE | - | - | - |
| FLOAT | - | - | - | - | - | - | SQL_FLOAT | - | - | - |
| GRAPHIC | - | - | - | - | - | - | SQL_WCHAR | - | - | - |
| INTEGER | - | - | - | - | - | - | SQL_INTEGER | - | - | - |
| REAL | - | 4 | - | - | - | - | SQL_REAL | - | - | - |
| SMALLINT | - | - | - | - | - | - | SQL_SMALLINT | - | - | - |
| TIME | - | 3 | - | - | - | - | SQL_TYPE_TIME | - | - | - |
| TIMESTAMP | - | 10 | - | - | - | - | SQL_TYPE_TIMESTAMP(p) | - | - | - |
| VARCHAR | - | - | - | - | Y | - | SQL_VARBINARY | - | - | - |
| - | - | - | - | N | - | SQL_VARCHAR | - | - | - | |
| VARGRAPHIC | - | - | - | - | Y | - | SQL_WVARCHAR | - | - | - |
| Note:
|
||||||||||