Edit Question

Title Body

I have a field, justsomenum, of type decimal(3,2) in MySQL that seems to always have values of 9.99 when I insert something like 78.3. Why? This is what my table looks like: mysql> describe testtable; +---------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+--------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | firstname | varchar(20) | YES | | NULL | | | lastname | varchar(20) | YES | | NULL | | | justsomenum | decimal(3,2) | YES | | NULL | | +---------------+--------------+------+-----+---------+----------------+ When I insert something like this and the select: mysql> insert into testtable (firstname, lastname, justsomenum) values ("Lloyd", "Christmas", 83.5); I get 9.99 when I select. mysql> select * from testtable; +----+-----------+-----------+---------------+ | id | firstname | lastname | justsomenum | +----+-----------+-----------+---------------+ | 1 | Shooter | McGavin | 9.99 | | 2 | Lloyd | Christmas | 9.99 | | 3 | Lloyd | Christmas | 9.99 | | 4 | Lloyd | Christmas | 9.99 | +----+-----------+-----------+---------------+ 4 rows in set (0.00 sec) This is MySQL 5.0.86 on Mac OS X 10.5.8. Any ideas? Thanks.

Tags (comma-separated) Cancel