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. 
>Pat...

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