PDA

View Full Version : mysql decimal(14,4) in field model use auto or float type ?



maneljn
16 Sep 2013, 9:36 AM
i have some columns defined in mysql decimal(14,4)

in field model which is the best way to do accounting and currency operations ? use "auto" or "float" type
?

ettavolt
17 Sep 2013, 8:30 AM
Float, because javascript will anyway use a Number primitive for this.

maneljn
17 Sep 2013, 8:41 AM
it's possible that "float" type could add some calculating errors with very little and very big numbers , due to internal representation ?