MYSQL: DECIMAL with accuracy of 10 digits after the comma

Viewed 16678

In MySQL I have a DECIMAL field set to 10,10. However, whenever I enter a new value, it shows 0.9999999999. What would I need to change to accept any number with an accuracy of 10 digits after the comma? It does work with 10,6 for some reason.

PS: I want to insert exchange rates.

3 Answers
Related