データ型マッピング
データ型のマッピング
本製品 は、データソースの型を、スキーマで使用可能な対応するデータ型にマッピングします。以下のテーブルはこれらのマッピングを説明します。
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 |