Table of ContentsPreviousNext

Ispirer             Ispirer


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.


Table of ContentsPreviousNext
Ispirer             Ispirer
Copyright © 1999-2015 Ispirer Systems Ltd. Ispirer and SQLWays are trademarks of Ispirer Systems Ltd. All other product names may be trademarks of the respective companies. All rights reserved.