Best datatype for prices without decimals

donboe · October 13, 2011, 12:13pm

What would be the best datatype for prices without decimals? E.a. 560, 650, 920 etc

Thank you in advance

r937 · October 13, 2011, 2:58pm

SMALLINT UNSIGNED, MEDIUMINT UNSIGNED, or INTEGER UNSIGNED – depending on the maximum price

Topic		Replies	Views
Best way to store prices? Databases	5	653	July 5, 2010
Column Type for Price Field(DECIMAL or FLOAT or DOUBLE) Databases	3	9685	September 24, 2014
MySql data type for price/cost of product? Databases	8	19533	October 10, 2015
What data type is best for Databases	2	381	October 4, 2011
Need help for the dataype in my table Databases	8	1312	October 8, 2014