DECIMAL(precision,
scale)
The DECIMAL
data type is an exact signed numeric value with a variable precision and
scale. Precision refers to the total number of digits in the mantissa,
both left and right of the decimal point. Scale refers to the number of
digits right of the decimal point. The default values are precision =
17 and scale = 6.
The amount
of storage used by a decimal column is based on the actual value entered,
not on the default precision and scale values or the precision and scale
values entered when defining the column. To calculate the amount of storage
use the formula:
For example,
the number 9283.83 would be stored in 6 bytes. The calculation used to
determine this is shown below:
If you attempt
to move a value larger than the allowed maximum from a data type such
as FLOAT or DOUBLE, DBMaker displays a conversion error and does not move
the data. The DECIMAL data type may be abbreviated as DEC.
| e.g. |
3452.8373645 |
| |
736.383732652 |
<
DATE | Contents
| DOUBLE >
|
