Price storage (mysql)?

Question

MySQL

Tell me the correct choice of data type for the field with the price, I tend to double (15,2). Will there be any problems with the conversion?

Answer 1

Integer is the most reliable option. Plus the currency code in a separate field.

Answer 2

decimal with the required precision.
example decimal(19,2) - store accurate to kopecks
or take more precision - if necessary

Answer 3

MS SQL has the MONEY type, which is equivalent to NUMERIC(19,4).