11155
March 19, 2012, 12:41am
1
Rails 3.1.3
I have a field of type,
t.decimal "startp", :precision => 4, :scale => 1
which is of course, 13.2, 44.5, 123.9, and so on.
Once in a while, some of the values, which are either already stored in
DB or newly created, become something like,
9.80000000000000001 or 65.40000000000000000001
which was supposed to be 9.8 and 65.4 respectively (I did not count the
number of zeros precisely).
It does not happen all the time, it just does once in a while, and I am
not sure what's causing it.
Could anyone guess the cause of this issue?
soichi
It may be to do with how you are displaying the value that is causing
it to be converted to a float before being displayed. How are you
displaying the value in order to see it like that?
Colin
It may also have to do with the way the value is assigned to the
ActiveRecord setter method.
suppose you had a class "Race" with startp as one of the
decimal column, then this
race.startp = 9.8
will first make a Float 9.8 and then assign that Float to the
BigDecimal value.
You may try:
race.startp = "9.8" # you could use the user supplied string
race.startp = BigDecimal.new("9.8")
HTH,
peter