Storing points in to a PMA table?

[Script47]

How do you store numbers with points in a PMA table. So what data type do I use?

I figured out how to do it, you have to use double. For some reason decimal didn't work (which I thought it would be because of the name). If anyone knows why it didn't work, please post as it would clear up and will help me and other too.

Edited December 25, 2013 by Script47

[Guest]

decimal?

m2s

[Script47]

decimal?

m2s

I tried that, however when I then put a number like 1.2, it will automatically change to 1, any ideas why?

[Guest]

Do you have decimal (1, 5)?

http://stackoverflow.com/questions/6525180/mysql-decimal-with-accuracy-of-10-digits-after-the-comma

[Script47]

Do you have decimal (1, 5)?

http://stackoverflow.com/questions/6525180/mysql-decimal-with-accuracy-of-10-digits-after-the-comma

Sorry, forgot to say, this link helped me fix it. Thanks.