Question

How to store decimal value in Android sqlite?

Answer 1

The defined column type affinity TEXT, REAL, NUMERIC, VARCHAR, RUMPLESTILTSKIN (yes it works), has little impact; the exception being if the type is either INTEGER PRIMARY KEY or INTEGER PRIMARY KEY AUTOINCREMENT in which case the column is an alias of the SQLITE column rowid and cannot be used. ROWIDs and the INTEGER PRIMARY KEY