REAL data type

The REAL data type is used to store single-precision floating-point numbers stored in 4 bytes.

Syntax
REAL
Remarks

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

See also
Standards and compatibility
  • SQL/2003   Compatible with SQL/2003.