Enter approximate numeric types—`float`, `real`, and
`double precision`—as a mantissa followed by an optional exponent.

The mantissa can include a positive or negative sign and a decimal point. The exponent, which begins after the character “e” or “E”, can include a sign but not a decimal point.

To evaluate approximate numeric data, SAP ASE multiplies the mantissa by 10 raised to the
given exponent. This table shows examples of `float`, `real`,
and `double precision` data:

Data Entered |
Mantissa |
Exponent |
Value |
---|---|---|---|

10E2 |
10 |
2 |
10 * 10 |

15.3e1 |
15.3 |
1 |
15.3 * 10 |

-2.e5 |
-2 |
5 |
-2 * 10 |

2.2e-1 |
2.2 |
-1 |
2.2 * 10 |

+56E+2 |
56 |
2 |
56 * 10 |

The column’s binary precision determines the maximum number of binary digits allowed in the
mantissa. For `float` columns, you can specify a precision of up to 48
digits; for real and double precision columns, the precision is machine-dependent. If a
value exceeds the column’s binary precision, SAP ASE flags the entry as an error.

Created May 28, 2014. Send feedback on this help topic to Technical Publications: pubs@sap.com