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.* Quote 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 Quote 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. Quote Link to comment https://forums.phpfreaks.com/topic/133413-what-datatype-ideal/#findComment-694392 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.