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 |
Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.