Tag Archives: decimal

monetary data: decimal vs. double

Share The DECIMAL and NUMERIC data types are used to store exact numeric data values. In MySQL, NUMERIC is implemented as DECIMAL. These types are used to store values for which it is important to preserve exact precision, for example … Continue reading

Posted in mysql | Tagged , , , , | Leave a comment

Which is best for monetary data: double, float, decimal

ShareFor floating-point data types, MySQL uses four bytes for single-precision values and eight bytes for double-precision values. The FLOAT and DOUBLE data types are used to represent approximate numeric data values. For FLOAT the SQL standard allows an optional specification … Continue reading

Posted in mysql | Tagged , , , , , | Leave a comment