Store long float MySQL

Question

What kind of data type should I choose in MySQL to store digit like this 50.078294547389426

It depends. What precision do you need? Do you want binary or decimal? How important is performance? What do you know about the other values that will be in the field? — Matthew Flaschen, Oct 21 '10 at 11:30
Even though the question is newer than this one, there is some good discussion here: http://stackoverflow.com/questions/5150274/difference-between-float-and-decimal-data-type — Sean Fahey, Sep 30 '13 at 22:53

score 0 · Answer 1 · answered Oct 21 '10 at 11:34

0

Initially id look at float but id try to get more of an idea of what sort of data your looking at first.

answered Oct 21 '10 at 11:34

wmitchell

score 0 · Answer 2 · answered Oct 21 '10 at 14:09

0

Use Float or double

answered Oct 21 '10 at 14:09

zod

2 Answers2