I am using SQLite and need to store prices. SQLite's
REAL data-type says it uses
floating-point which is unacceptable storage for prices. Is there a data-type besides TEXT that I can use to store prices numerically so they sort correctly?
Certainly, use integer
You will have to decide how many decimal places you are assuming and be consistent at the application level.