field type: decimal vs. float

There are plenty of good explanations about the difference between float and decimal out there, e.g.:

The official docs have some hints on the differences:
https://dev.mysql.com/doc/refman/8.0/en/floating-point-types.html

Floating-Point Types (Approximate Value) - FLOAT

So for most business cases / CRM calculations, we’d use decimals.

1 Like