Hi Andrew
Consider using NUMERIC or DECIMAL to maintain precision.
>From the manual:
The NUMERIC and DECIMAL types are implemented as the same type by MySQL,
as permitted by the SQL-92 standard. They are used for values for which
it is important to preserve exact precision, for example with monetary
data. When declaring a column of one of these types the precision and
scale can be (and usually is) specified; for example:
salary DECIMAL(5,2)
Regards,
Matt
------------------------------------------------------------------------
----------------------------------------------
That's how floating-point numbers work generally, not just in MySQL. Why
are you so concerned about it? Presumably your 0.012345 isn't an
exact number but a measurement of some sort, so it could just as well
be 0.0123449 or 0.0123451, and 0.01234 is perfectly fine as a rounded
value.
If you do have exact numbers with six decimal places, you're probably
better off storing them as some sort of integer and adding the
decimal point when necessary for display.
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.562 / Virus Database: 354 - Release Date: 1/16/2004
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
