>>> For a 10,2 decimal column, should this be a valid number: 1234567890.12?
It's easy to test:
mysql> CREATE TABLE t (d DECIMAL(10,2));
Query OK, 0 rows affected (0.01 sec)
mysql> INSERT INTO t SET d = 1234567890.12;
Query OK, 1 row affected (0.01 sec)
mysql> SELECT * FROM t;
+--------------+
| d |
+--------------+
| 999999999.99 |
+--------------+
1 row in set (0.00 sec)
The value's been clipped to the upper end of the range.
Your next question should be why that value has 9 digits to the left
of the decimal point. :-)
How did you guess! This behaviour is why I asked the question in the first
place. Why does it get clipped for a 10 digit number. Without the decimal
value I believe it inserts correctly, but with the 2 decimal places it get
clipped...
--
Michael She : [EMAIL PROTECTED]
Mobile : (519) 589-7309
WWW Homepage : http://www.binaryio.com/
mysql> INSERT INTO t SET d = 1234567890.12;
Query OK, 1 row affected (0.01 sec)
A different question would be why does MySQL not generate an error or
warning on the insert when it mangled the value?
The philosophy is that it's the clients responsibility not to insert
bad data.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
