Fixed-point data
Fixed-point data is a decimal value with a fixed number of digits to the right and left of the decimal point. The fixed number of digits to the right of the decimal point is called the scale of the value. The total number of digits in the fixed-point value is called the precision of the value.
The DataBlade®
API provides
support for the following kinds of fixed-point data (which correspond
to existing SQL data types).
| Type of fixed-point value | SQL data type |
|---|---|
| Decimal | DECIMAL(p,s) |
| Monetary | MONEY(p) |
Each of these kinds of fixed-point values has a text and a binary representation.