|
Ispirer SQLWays Database Migration Software
DOUBLE, DOUBLE PRECISION and REAL
DOUBLE[(p,s)] [UNSIGNED]
A normal-size (double-precision) floating-point number. Allowable values are -1.7976931348623157E+308 to -2.2250738585072014E-308, 0, and 2.2250738585072014E- 308 to 1.7976931348623157E+308.
The p is the precision, or the total number of digits. The s is the scale, or the number of digits to the right of the decimal point.
DOUBLE without arguments stands for a double-precision floating-point number.
If UNSIGNED is specified, negative values are not allowed.
DOUBLE PRECISION[(p,s)] [UNSIGNED]
REAL[(p,s)] [UNSIGNED]
These are synonyms for DOUBLE.