Default forward data type mappings for BigSQL data sources
The following table lists the default forward data type mappings for BigSQL data sources.
| Remote Typename | Remote Lower Len | Remote Upper Len | Remote Lower Scale | Remote Upper Scale | Remote Bit Data | Remote Data Operators | Federated Typename | Federated Length | Federated Scale | Federated Bit Data |
|---|---|---|---|---|---|---|---|---|---|---|
| ARRAY | - | - | - | - | - | - | NOT SUPPORT | - | - | - |
| BIGINT | - | - | - | - | - | - | BIGINT | 8 | - | - |
| BINARY | - | - | - | - | - | - | BINARY | - | - | - |
| BOOLEAN | - | - | - | - | - | - | SMALLINT | 2 | - | - |
| CHAR | - | - | - | - | - | - | CHARACTER | - | - | - |
| DATE | - | - | - | - | - | - | DATE | 4 | - | - |
| DECIMAL | - | - | - | - | - | - | DECIMAL | - | - | - |
| DOUBLE | - | - | - | - | - | - | DOUBLE | 8 | - | - |
| FLOAT | - | - | - | - | - | - | DOUBLE | 8 | - | - |
| INTEGER | - | - | - | - | - | - | INTEGER | 4 | - | - |
| REAL | - | - | - | - | - | - | REAL | 4 | - | - |
| SMALLINT | - | - | - | - | - | - | SMALLINT | 2 | - | - |
| STRING | - | - | - | - | - | - | VARCHAR | 32672 | - | - |
| STRUCT | - | - | - | - | - | - | NOT SUPPORT | - | - | - |
| TIMESTAMP | - | - | - | - | - | - | TIMESTAMP | 12 | 9 | - |
| TINYINT | - | - | - | - | - | - | SMALLINT | 2 | - | - |
| VARBINARY | - | - | - | - | - | - | VARCHAR(n) | - | - | - |
| VARCHAR | - | - | - | - | - | - | VARCHAR | - | - | - |