Re: floating number error - Christopher R. Jones - com.mysql.lists.mysql

6 messages in com.mysql.lists.mysqlRe: floating number error

From	Sent On	Attachments
D. Goorvitch 4-5502	29 Jun 2000 15:40
sin...@mysql.com	30 Jun 2000 05:00
Michael Widenius	30 Jun 2000 15:34
Christopher R. Jones	01 Jul 2000 17:02
sin...@mysql.com	02 Jul 2000 05:48
Michael Widenius	02 Jul 2000 10:30

Subject:	Re: floating number error
From:	Christopher R. Jones (cj...@interlog.com)
Date:	07/01/2000 05:02:27 PM
List:	com.mysql.lists.mysql

The problem is that you are using MySQL 3.22, which didn't have support for the true floating point format. The fix is to upgrade to 3.23 and define the column as

I am wondering what is the accuracy of 3.22.XX for floating point numbers. I have a number of fields defined as Float(4). The most accurate number stored is to 3 decimal places, ie. 34.695

Will I run into problems?