|
Ispirer SQLWays Database Migration Software
float, double precision and real
Approximate number data types for use with floating point numeric data. Floating point data is approximate; not all values in the data type range can be precisely represented.
float[(precision)]
Floating point number. Storage size is 4 bytes if precision < 16, and 8 bytes if precision >= 16. The range and storage precision is machine dependent.
float columns with a precision of 1-15 are stored as real; those with higher precision are stored as double precision.
double precision
Floating point number. Storage size is 8 bytes. The range and storage precision is machine dependent.
real
Floating point number. Storage size is 4 bytes. The range and storage precision is machine dependent.