データタイプ名 |
基本タイプ |
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) |
<g1>定数名</g1> |
型 |
値 |
BOOLEAN FALSE |
BOOLEAN |
false |
BOOLEAN TRUE |
BOOLEAN |
true |