Web lists-archives.com

Re: mysql float data type

On 17 December 2014 14:21:40 CET, Patrick Sherrill <patrick@xxxxxxxxxxxxxxxxxx> wrote:
>We always store as strings to avoid rounding issues and then convert
>for calcs to whatever precision we need. 

So you'll still be affected by rounding errors during conversion and calculation,
two problems you'd avoid when using DECIMAL instead ...
Hartmut Holzgraefe, Principal Support Engineer (EMEA)
MariaDB Corporation | http://www.mariadb.com/

MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql