Which column type is the safest choice for storing money amounts?
DOUBLE PRECISIONREALFLOAT(24)DECIMAL(12,2)
Binary floating point can't represent values like 0.10 exactly; fixed-point
Play SQL & Databases ▸
DECIMAL/NUMERIC avoids rounding drift.