Best field type for price field

Question

What is the best field type for the price in MySQL and PostgreSQL due the date?

[any number].[always two digits, except when value is 0]

oh, it works. Could you add this as an answer? Thanks! – Gediminas Šukys Feb 04 '14 at 10:01 — Gediminas Šukys, Feb 04 '14 at 10:01
Alternatively, just delete the question – Strawberry Feb 04 '14 at 10:02 — Strawberry, Feb 04 '14 at 10:02

score 2 · Accepted Answer · answered Feb 04 '14 at 10:02

2

You should use decimal for MySQL. PostgreSQL also supports that

answered Feb 04 '14 at 10:02

Alexander

score 0 · Answer 2 · answered Feb 04 '14 at 10:01

0

DECIMAL in both, and no, this is not an "opinion-based question". :)

answered Feb 04 '14 at 10:01

Leonid Shevtsov

score 0 · Answer 3 · answered Feb 04 '14 at 10:02

0

I would use something like NUMERIC(15,2) for MySQL and the built-in MONEY data type in PostgreSQL.

answered Feb 04 '14 at 10:02

Kouber Saparev

3 Answers3