how to store real number with precision size

[PawanGhewande]

I want to store value in db like 1.40 & 1.04, Im currently using RealColumn() so it stores 1.4 and also return the same for both values,

I really don't know how I can solve this issue.

[frankvollebregt]

One solution would be to use type converters to achieve this. You can store a number (under the hood) but convert to and from a given precision value when reading and writing to the database.

[simolus3]

I also recommend this approach! Sqlite has not builtin type for fixed-precision numbers, so I think a type converter is the best approach to handle this somewhat transparently.