TDV Data Types | Local File Storage Data Types |
DECIMAL_FLOAT | VARCHAR(128) |
BIGINT | BIGINT |
BINARY | BYTEA |
BINARY_PROMOTE | BYTEA |
BIT | SMALLINT |
BLOB | BYTEA |
BOOLEAN | BOOLEAN |
CHAR | CHAR(&1) |
CHAR_PROMOTE | TEXT |
CLOB | TEXT |
DATE | VARCHAR |
DECIMAL | DECIMAL(&p, &s) |
DECIMAL_PROMOTE | TEXT |
DOUBLE | DOUBLE |
FLOAT | FLOAT |
INTEGER | INTEGER |
NUMERIC | DECIMAL(&p, &s) |
NUMERIC_PROMOTE | TEXT |
REAL | REAL |
SMALLINT | SMALLINT |
TIME | VARCHAR |
TIMESTAMP | TIMESTAMP |
TINYINT | SMALLINT |
VARBINARY | BYTEA |
VARBINARY_PROMOTE | BYTEA |
VARCHAR | VARCHAR(&1) |
VARCHAR_PROMOTE | TEXT |
XML | XML |
INTERVAL_YEAR | INTERVAL YEAR |
INTERVAL_MONTH | INTERVAL MONTH |
INTERVAL_DAY | INTERVAL DAY |
INTERVAL_HOUR | INTERVAL HOUR |
INTERVAL_MINUTE | INTERVAL MINUTE |
INTERVAL_SECOND | INTERVAL SECOND |
INTERVAL_YEAR_TO_MONTH | INTERVAL_YEAR_TO_MONTH |
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_TO_MINUTE | INTERVAL HOUR TO MINUTE |
INTERVAL_HOUR_TO_SECOND | INTERVAL HOUR TO SECOND |
INTERVAL_MINUTE_TO_SECOND | INTERVAL MINUTE TO SECOND |