Please, note, that Ispirer SQLWays 6.0 is no longer supported and provided to clients.

You can try out automated conversion of databases and applications with Ispirer Toolkit for free. Download free trial.

Check out the relevant toolkit documentation.

Ispirer SQLWays Database Migration Software

float, double 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 < 25, and 8 bytes if precision >= 25. The range and storage precision is machine dependent.

float columns with a precision of 1-24 are stored as float; those with higher precision are stored as double.

double

Floating point number. The value range is from 2.22507385850721e-308 through 1.79769313486231e+308. Storage size is 8 bytes. The range and storage precision is machine dependent.

real

Floating point number. The value range is from 1.175495e-38 through 3.402823e+38. Storage size is 4 bytes. The range and storage precision is machine dependent.