SQL Server – Best Data Type for Storing Monetary Values

Something like Decimal(19,4) usually works pretty well in most cases. You can adjust the scale and precision to fit the needs of the numbers you need to store. Even in SQL Server, I tend not to use "money" as it's non-standard.

Since money needs an exact representation don't use data types that are only approximate like float. You can use a fixed-point numeric data type for that like

decimal(15,2)

• 15 is the precision (total length of value including decimal places)
• 2 is the number of digits after decimal point
• The max possible number in this example would be 9999999999999.99

See MySQL Numeric Types:

These types are used when it is important to preserve exact precision, for example with monetary data.