Extend precision of MySQL's double datatype?
I am trying to save the value "6.714285714285714" into a DOUBLE datatype field.
Unfortunately, it does not fit at all and is trimmed by one digit. Storing larger numbers becomes less precise.I have already searched in the mysql manual and it seems to be th开发者_StackOverflow社区at double is the most precise data type available. Does anyone know a practical workaround?
DECIMAL is a better choice than DOUBLE if you need precision.
精彩评论