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] |
Database Studio, Creating Columns
SQL Reference Manual, Data Type (data_type)
Loader, Data Types