
Defining domains
Numeric data types
Conceptual data type
Integer
Short Integer
Long Integer
Byte
Number
Decimal
Float
Short Float
Long Float
Money
Serial
Boolean
What it stores
256 values
Numbers with a fixed decimal point
Numbers with a fixed decimal point
Less than
Numbers with a fixed decimal point
Automatically incremented numbers
Two opposing values (true/false; yes/no; 1/0)
Length?
—
—
—
—
Fixed
Fixed
Fixed
—
—
Fixed
Fixed
—
Precision?
—
—
—
—
·
—
—
—
·
—
—
Character data types
Conceptual data type
Characters
Variable Characters
Long Characters
Long Var Characters
Text
Multibyte
Variable Multibyte
What it stores
Character strings
Character strings
Character strings
Character strings
Character strings
Multibyte character strings
Multibyte character strings
Length?
Fixed
Maximum
Maximum
Maximum
Maximum
Fixed
Maximum