Data Type
| Kind of Values Stored
|
ARRAY OF type
| Arrays of values of any other single data type.
|
BYTE
| Any kind of binary data.
|
CHAR
| Character strings of up to 32,767 ASCII characters.
|
CHARACTER
| (This keyword is a synonym for CHAR.)
|
DATE
| Points in time, specified as calendar dates.
|
DATETIME
| Points in time, specified as calendar dates and time-of-day.
|
DEC
| (This keyword is a synonym for DECIMAL.)
|
DECIMAL
| Fixed point numbers, of a specified scale and precision.
|
DOUBLE PRECISION
| (These keywords are a synonym for FLOAT.)
|
FLOAT
| Floating-point numbers, of up to 32-digit precision.
|
INT
| (This keyword is a synonym for INTEGER.)
|
INTEGER
| Whole numbers, from -2,147,483,647 to +2,147,483,647.
|
INTERVAL
| Spans of time in years and months, or else in smaller time units.
|
MONEY
| Currency amounts, with definable scale and precision.
|
NUMERIC
| (This keyword is a synonym for DECIMAL.)
|
REAL
| (This keyword is a synonym for SMALLFLOAT.)
|
RECORD
| Ordered sets of values, of any combination of 4GL data types.
|
SMALLFLOAT
| Floating-point numbers, of up to 16-digit precision.
|
SMALLINT
| Whole numbers, from -32,767 to +32,767.
|
TEXT
| Character strings of any length.
|
VARCHAR
| Character strings of varying length, no greater than 255.
|
Except for ARRAY and RECORD, each of these corresponds to a data type of SQL.
(The SERIAL type of SQL is not a 4GL data type. You can use variables of the
INTEGER data type to store SERIAL values from the database.)
TEXT and BYTE are called the large data types; ARRAY and RECORD are called the
structured data types. All other 4GL data types are simple data types.