From: Dan Nelson
Date: April 13 2003 5:39am
Subject: Re: rounding/truncation of decimal fields
List-Archive: http://lists.mysql.com/mysql/137118
Message-Id: <20030413053956.GB93904@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Apr 13), Matt Loschert said:
> That may be the case, but I would assume (again, I guess incorrectly)
> that on a given architecture, the following two values would be
> treated identically.  Is quoting really supposed to change the
> representation of the number?

Most definitely.

> CREATE TABLE test1 (field1 decimal(12,2));
> INSERT INTO test1 VALUES ('0.005');
> INSERT INTO test1 VALUES ( 0.005 );
> SELECT * FROM test1;
> +--------+
> | field1 |
> +--------+
> |   0.00 |
> |   0.01 |
> +--------+
> 2 rows in set (0.02 sec)

The first is inserting a string value, which is probably just copied
directly into the DECIMAL field (with truncation).  The second is
inserting a floating-point value, which has to have been parsed from
the original ASCII SQL statement into a float, then converted back into
ASCII to store into the DECIMAL field.

-- 
	Dan Nelson
	dnelson@stripped