The REAL data type is used to store single-precision floating-point numbers stored in 4 bytes.
REAL
The REAL data type is an approximate numeric data type; it is subject to roundoff errors after arithmetic operations.
The range of values is -3.402823e+38 to 3.402823e+38, with numbers close to zero as small as 1.175494e-38. Values held as REAL are accurate to 7 significant digits, but may be subject to round-off error beyond the sixth digit.
The approximate nature of REAL values means that queries using equalities should generally be avoided when comparing REAL values
SQL/2003 Compatible with SQL/2003.
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |