The REAL data type is used to store single-precision floating-point numbers stored in 4 bytes.
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.
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|