MySQL

Storing Currency Values and Float Precision

When I was a junior developer, I was looking through a database schema and noticed that currency values are stored in Integers and that each value is multiplied by 100. This was an intriguing approach, and I began to look into it. It was fascinating back then because I thought we could use a type like a Float to store this without having to use multiplication or division hackle. This article will explain why we avoid Float and Double in favor of cleaner solutions. This is an important strategy to consider. So, let's get started.

Read