Numbers 

The numeric data types supported by Open SQL are binary integer, floating-point and decimal. Binary numbers are exact representations of integers, decimal numbers are exact representations of real numbers and floating-point numbers are approximate representations of real numbers.

Binary integer includes the types SMALLINT, INTEGER and BIGINT with value ranges that correspond to the Java types short, int and long. 

Floating-point includes the single precision type REAL and the double precision type DOUBLE. Because not all supported database platforms adhere to the IEEE 754 standard for floating-point numbers, Open SQL defines smaller value ranges for these types than the IEEE 754 standard.

A DECIMAL value is a decimal number with an implicit decimal point. The position of the decimal point is determined by the precision and the scale of the number. The scale, which is the number of digits in the fractional part of the number, cannot be negative or greater than the precision. The maximum precision is 31 digits. All values of a decimal column have the same precision and scale.