Precision, scale, length, and display size
The functions that get and set precision, scale, length, and display size for SQL values have size limitations for their input arguments.
Therefore, these values are limited to the size of an SDWORD that
has a maximum value of 2,147,483,647. The following table describes
these values.
| Value | Description for a numeric data type | Description for a non-numeric data type |
|---|---|---|
| Precision | Maximum number of digits. | Either the maximum length or the specified length. |
| Scale | Maximum number of digits after the decimal point. For floating point values, the scale is undefined because the number of digits to the right of the decimal point is not fixed. | Not applicable. |
| Length | Maximum number of bytes that a function returns when a value is transferred to its default C data type. | Maximum number of bytes that a function returns when a value is transferred to its default C data type. The length does not include the NULL termination byte. |
| Display size | Maximum number of bytes needed to display data in character form. | Maximum number of bytes needed to display data in character form. |