Data Type Name | Base Type |
BIGINT | BIGINT |
BINARY | BINARY(1024) |
BIT | BIT |
BLOB | BLOB |
BOOLEAN | BOOLEAN |
CHAR | CHAR(255) |
CLOB | CLOB |
DATE | DATE |
DECIMAL | DECIMAL(32,2) |
DOUBLE | DOUBLE |
FLOAT | FLOAT |
INTEGER | INTEGER |
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 MONTH | INTERVAL MONTH |
INTERVAL SECOND | INTERVAL SECOND |
INTERVAL YEAR | INTERVAL YEAR |
INTERVAL YEAR TO MONTH | INTERVAL YEAR TO MONTH |
LONGVARBINARY | VARBINARY(1024) |
LONGVARCHAR | VARCHAR(2147483647) |
NUMERIC | NUMERIC(32,0) |
REAL | FLOAT |
SMALLINT | SMALLINT |
TIME | TIME |
TIMESTAMP | TIMESTAMP |
TINYINT | TINYINT |
VARBINARY | VARBINARY(1024) |
VARCHAR | VARCHAR(255) |
Constant Name | Type | Value |
BOOLEAN FALSE | BOOLEAN | false |
BOOLEAN TRUE | BOOLEAN | true |