HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMajor

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

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
storingwhatsqlitetypepricesusedata

Problem

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?

Solution

Use an integer & 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.

Context

StackExchange Database Administrators Q#15729, answer score: 34

Revisions (0)

No revisions yet.