Storing prices in SQLite, what data-type to use?
Use an integer &amp; store the prices as the lowest common unit. So, for dollars and cents you'd store it in cents. EG: $1.00 would be stored as 100.

In my experience it's standard practice.