stig1 Posted November 19, 2008 Share Posted November 19, 2008 I am in the process of creating a database which will hold prices, shipping rates, etc. Basically money values. I need some of my price fields to have the ability to have the following: 999999.9999 others to just have 999.99 Which is the ideal datatype to store currency values? I used double but I always was getting out of range errors, etc. Using MySQL 5.* Link to comment https://forums.phpfreaks.com/topic/133413-what-datatype-ideal/ Share on other sites More sharing options...
CroNiX Posted November 20, 2008 Share Posted November 20, 2008 probably just decimal. DECIMAL(10,5) would mean 10 digits, 5 of them for the decimal xxxxx.xxxxx Link to comment https://forums.phpfreaks.com/topic/133413-what-datatype-ideal/#findComment-693994 Share on other sites More sharing options...
fenway Posted November 20, 2008 Share Posted November 20, 2008 Yes... don't use FLOAT/DOUBLE, it's evil. Link to comment https://forums.phpfreaks.com/topic/133413-what-datatype-ideal/#findComment-694392 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.