Data Type Mapping
Data Type Mappings
The provider maps types from the data source to the corresponding data type available in the schema. The table below documents these mappings.
| ARRAY | MyArrayName |
| BYTE | BYTE |
| BLOB | BLOB |
| CHAR | CHAR |
| DATASET | DATASET |
| DATE | date |
| TIME | time |
| TIMESTAMP | datetime |
| TIME WITH TIME ZONE | TIME WITH TIME ZONE |
| TIMESTAMP WITH TIME ZONE | TIMESTAMP WITH TIME ZONE |
| ST_Geometry | ST_GEOMETRY |
| MBR | MBR |
| INTERVAL YEAR | INTERVAL YEAR |
| INTERVAL YEAR TO MONTH | INTERVAL YEAR TO MONTH |
| INTERVAL MONTH | INTERVAL MONTH |
| INTERVAL DAY | INTERVAL DAY |
| INTERVAL DAY TO HOUR | INTERVAL DAY TO HOUR |
| INTERVAL DAY TO MINUTE | INTERVAL DAY TO MINUTE |
| INTERVAL DAY TO SECOND | INTERVAL DAY TO SECOND |
| INTERVAL HOUR | INTERVAL HOUR |
| INTERVAL HOUR TO MINUTE | INTERVAL HOUR TO MINUTE |
| INTERVAL HOUR TO SECOND | INTERVAL HOUR TO SECOND |
| INTERVAL MINUTE | INTERVAL MINUTE |
| INTERVAL MINUTE TO SECOND | INTERVAL MINUTE TO SECOND |
| INTERVAL SECOND | INTERVAL SECOND |
| JSON | JSON |
| BYTEINT | BYTEINT |
| SMALLINT | SMALLINT |
| INTEGER | int |
| BIGINT | bigint |
| DECIMAL | decimal |
| NUMERIC | decimal |
| FLOAT | DOUBLE PRECISION |
| REAL | DOUBLE PRECISION |
| DOUBLE PRECISION | DOUBLE PRECISION |
| NUMBER | NUMBER |
| PERIOD(DATE) | PERIOD DATE |
| PERIOD(TIME) | PERIOD TIME |
| XML | XML |