which data type should i use for storing the decimal numbers.
Query 1, which is causing the confusion
Agile Web 3rd edition , page 80 tip says, we should use decimals as
they are scaled to integer in rails as well as databases.
First of all what do they mean by scaling. Basically how doe they
decide the precision if I do not tell them. So if i enter a value
23.456 how do they decide if they should store 234 or 2345 or 23456
The test I tried has
t.decimal :price t.float :rate t.integer :cost
When i enter the values 34.54 , 43.54 and 123.45
the values that get stored in database are 34, 43.54 and 123.
Why is 34.54 getting converted to 34 only
do I need to specify :precision and :scale necessarily for scaling to
happen in decimals.
I know the hazards of using floats. …they will ditch me on
customer’s machine only…but I have already written some 20
migrations using float as data type… Is there any safe way to rescue
if I know I am storing the price and it will always be within 0 and