INT MS MYSQL DataTypes

[d2g]

I'm trying to get a grasp on mysql data types.

have this number

1234567.8900

What do i set mysql column too in order to store this number.

Using INT(11) this number is stored as 1.23456e+06 and is pulled out in my script as 1234570.00

thanks in advance!

D2G

 

[TonyGroves]

For a floating-point value, you could use either DOUBLE (8 bytes, range approx ±2e±308) or FLOAT (4 bytes, range approx ±2e±38). If it's fixed decimal places, you could either use DECIMAL(width,precision), though this is quite inefficient, or store the digits as an integer type like BIGINT (8 bytes), multiplying by 10000 before storage, and dividing again after retrieval.

 

[d2g]

i meant 1234567.8901 above.. I need to be able to store this number in the column as is.

Thanks!

 

[d2g]

thanks ill check into the above and run some tests.

thanks!