data type recommendation for height, width and length
i have to modify a shopping cart's product table to include height, width and length and wondering what datatype i should use?,
can someone please make a recommendation?
Pick your unit of measure, then make the column integer if you only want whole units, or decimal if you want fractional amounts. (You could use float, but in this case I'd think of it like money, where you normally only want a max of 2 decimal places, and in this case you might want only 1 decimal place, at least if it's inches or centimeters.)
"Please give us a simple answer, so that we don't have to think, because if we think, we might find answers that don't fit the way we want the world to be."
~ Terry Pratchett in Nation
How to Ask Questions the Smart Way
(not affiliated with this site, but well worth reading)
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)