Numeric and monetary formats
When the HCL OneDB™ product reads a string that contains numeric or monetary data, it uses the display format to determine how to convert this string to the internal value for the database column.
When the HCL OneDB product prints a string that contains numeric or monetary data, it uses the display format to determine how to format the internal value for the database column as a string.
- The decimal-separator symbol separates the part of the numeric value from the fractional part. In the default locale, the period is the decimal separator (3.01). In a locale such as French, the comma is the decimal separator (3,01).
- The thousands-separator symbol can show between groups of digits in the part of the numeric value. In the default locale, the comma is the thousands separator (3,255). In a French locale, the space is the thousands separator (3 255).
- The characters that indicate positive and negative numbers.
- The number of digits to group between each appearance of a non-monetary thousands separator.
For example, this might specify that numbers always omit the separator after the millions position, which produces the following output: 1234,345.
In addition to this notation, monetary data also uses a currency symbol to identify the currency unit. This can show at the front ($100) or back (100FF) of the monetary value. In this publication, the combination of currency symbol, decimal separator, and thousands separator is called currency notation.