The data type specifies which values a table column is allowed to contain.
Data Type |
Description in SQL Reference Manual |
---|---|
BOOLEAN |
|
CHAR[ACTER] (ASCII, BYTE, UNICODE) |
|
DATE |
|
FIXED |
|
FLOAT |
|
INT[EGER] |
|
CLOB [ASCII] CLOB UNICODE BLOB |
In earlier database versions, this data type was known as LONG. |
SMALLINT |
|
TIME |
|
TIMESTAMP |
|
VARCHAR (ASCII, BYTE, UNICODE) |