2.1.17 Numeric
The Numeric data type is functionally equivalent to the Decimal data type. Both data types support a range of values from -1038 + 1 through 1038 – 1. The user can specify the data type to have the following values for its Precision and Scale attributes.
Data type attribute |
Range |
Default |
---|---|---|
Precision |
From 1 through 38. |
18 |
Scale |
From 0 to the Precision that the user sets. |
0 |
The values of this data type are represented in simple Unicode string format, as follows.
-
Numeric = ["-"] 0*38DIGIT ["."0*38DIGIT]