Storing prices in SQLite, what data-type to use?

24 votes

2 answers

37308 views

                          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?
                        

Asked by unixman83 (343 rep)

Mar 28, 2012, 05:45 PM
Last activity: Feb 20, 2014, 12:57 PM

Storing prices in SQLite, what data-type to use?

Related Questions