Here I go with another question...
What is the safest column to use when dealing with monetary units, the precision required is only within 1 cent.
Do I use an INT and deal in cents, or use a FLOAT (I understand you can get weird things happen when doing multiple calcualtions... rounding etc), or something else?
I noticed this: salary DECIMAL(5,2) in:http://www.mysql.com/doc/N/u/Numeric_types.html , but I am not exactly sure about its use, or if it also has problems like the FLOAT.
http://www.iuni.com/...tware/web/index.html
Links Plugins
What is the safest column to use when dealing with monetary units, the precision required is only within 1 cent.
Do I use an INT and deal in cents, or use a FLOAT (I understand you can get weird things happen when doing multiple calcualtions... rounding etc), or something else?
I noticed this: salary DECIMAL(5,2) in:http://www.mysql.com/doc/N/u/Numeric_types.html , but I am not exactly sure about its use, or if it also has problems like the FLOAT.
http://www.iuni.com/...tware/web/index.html
Links Plugins