Re: mysql float data type
- Date: Wed, 17 Dec 2014 14:28:19 +0100
- From: Hartmut Holzgraefe <hartmut@xxxxxxxxxxx>
- Subject: 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