currency/Float/Double.. which is suitable for currency...

[MohsinAli]

currency/Float/Double..

I want to store amounts of purchasing, which data type should I use in Database to store these amounts...

And what is the difference in between them...

[imaginethis]

The mysql documentation suggests using DECIMAL. http://dev.mysql.com/doc/refman/5.0/...ric-types.html

[Raju Gautam]

Yes, it should look like this in case of MySQL

CREATE TABLE tablename (
              price DOUBLE(10,2) NOT NULL
            );

[r937]

do not use DOUBLE for money -- DOUBLE is the same as FLOAT and it is imprecise

see Problems with Floating-Point Comparisons

[kyberfabrikken]

Yes, whatever you do, you do NOT want to use floats. Use an integer inside PHP, and in the database, use either DECIMAL or INTEGER. To use an integer, you need to make the smallest unit primary. Eg. instead of 1 dollar and 50 cents, you count 150 cents.

[Raju Gautam]

do not use DOUBLE for money -- DOUBLE is the same as FLOAT and it is imprecise

see Problems with Floating-Point Comparisons

Umm sorry it was my TYPO if it can be believable because I never used DOUBLE yet in my applications.

CREATE TABLE tablename (
              price DECIMAL(10,2) NOT NULL
            );