I've run into a weird problem. If I try to insert this value, 78978978, into a FLOAT(9,2) column, the value changes. See below. System info: MySQL-shared-3.23.51-1 MySQL-client-3.23.51-1 MySQL-devel-3.23.51-1 MySQL-Max-3.23.51-1 MySQL-3.23.51-1 Red Hat Linux release 7.3 (Valhalla)
#####Wrong mysql> CREATE TABLE TIMMA ( AMOUNT FLOAT(10,2)); Query OK, 0 rows affected (0.01 sec) mysql> INSERT INTO TIMMA VALUES(78978978); Query OK, 1 row affected (0.00 sec) mysql> SELECT * FROM TIMMA; +-------------+ | AMOUNT | +-------------+ | 78978976.00 | +-------------+ 1 row in set (0.00 sec) #####Try again with different value mysql> DROP TABLE TIMMA; Query OK, 0 rows affected (0.00 sec) mysql> CREATE TABLE TIMMA ( AMOUNT FLOAT(10,2)); Query OK, 0 rows affected (0.00 sec) mysql> INSERT INTO TIMMA VALUES(98978978); Query OK, 1 row affected (0.01 sec) mysql> SELECT * FROM TIMMA; +-------------+ | AMOUNT | +-------------+ | 98978976.00 | +-------------+ 1 row in set (0.00 sec) sql, query -- Walter Anthony System Administrator National Electronic Attachment Atlanta, Georgia 1-800-782-5150 ext. 1608 "If it's not broke....tweak it" --------------------------------------------------------------------- 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 <mysql-unsubscribe-##L=##[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php