|
Data Type |
Original Value |
Value Stored |
Bytes Used |
|
DECIMAL(9,2) |
1.2 |
1.20 |
5 |
|
DECIMAL(9,2) |
1234567.89 |
1234567.89 |
5 |
|
DECIMAL(9,2) |
-1234567.89 |
-1234567.89 |
5 |
|
DECIMAL(18,9) |
1234567.89 |
1234567.890000000 |
8 |
|
DOUBLE |
1234567.89 |
1234567.89 |
8 |
|
FLOAT |
1234567.89 |
1234570 |
4 |
The Floating Point option took up the least space, however, floating point data is considered approximate data since they have a limited number of significant digits
The DECIMAL(18,9) option made sure I could fit any data into my field but it was as wasteful of Space as a DOUBLE
Fixed And Floating Point Behavior