Specifications

TABLE 8.6 Floating Point Data Types

Storage

Type Range (Bytes) Description

FLOAT(precision) depends on varies Can be used to specify

precision single or double

precision floating

point numbers.

FLOAT[(M,D)] ±1.175494351E-38 4 Single precision

±3.402823466E+38 floating point number.

These are equivalent

to FLOAT(4), but

with a specified

display width and

number of decimal

places.

DOUBLE[(M,D)] ±1.7976931348623157E 8 Doubleprecision

+308 floating point number.

±2.2250738585072014E These are equivalent

-308 to FLOAT(8)but with a

specified display width

and number of decimal

places.

DOUBLE Synonym for

PRECISION[(M,D)] as above DOUBLE[(M, D)].

REAL[(M,D)] as above Synonym for

DOUBLE[(M, D)].

DECIMAL[(M[,D])] varies M+2 Floating point number

stored as

char. The

range depends on M,the

display width.

NUMERIC[(M,D)] as above Synonym for DECIMAL.

Using MySQL

ART II

202

11 7842 CH08 3/6/01 3:38 PM Page 202