The floating-point data types
The database server supports the following data types
for floating-point values.
| SQL floating-point data type | ESQL/C or C language type | Range of values |
|---|---|---|
| SMALLFLOAT, REAL | float | Single-precision values with up to 9 significant digits |
| FLOAT, DOUBLE PRECISION | double | Double-precision values with up to 17 significant digits |
| DECIMAL(p) | decimal | Absolute value range 10-130 - 10124 |