#1199 2 decimal places in default field - problem

closed
5
2013-01-18
2012-10-19
Jim Ord
No

I have posted this in the forum with no response as yet - I believe it may be a bug...
I have a database table containing average daily kilometerage (if such a word exists) allowed, and having been done, for, and by, cars in a rental fleet.
I have set up both fields as decimal(11,2) in the type column of the table and have defaulted the 'allowed' field to 82.20 which shows correctly in the Structure Tab of phpMyAdmin but is rounded down to 82.00 in the Browse Tab and subsequently the database itself.
How can I insist on 2 decimal places for fields in my DB, if not by using decimal(11,2) in my Type column? I'm obviously missing something...

Discussion

  • Jim Ord

    Jim Ord - 2012-10-19
     
  • Marc Delisle

    Marc Delisle - 2012-10-21
    • assigned_to: nobody --> lem9
    • status: open --> pending
     
  • Marc Delisle

    Marc Delisle - 2012-10-21

    With phpMyAdmin 3.5.3 and MySQL 5.5.13, I cannot reproduce your problem. When inserting a row, I see 82.20, save the row and still see 82.20 when browsing.

    Did you try on http://demo.phpmyadmin.net ?

     
  • Jim Ord

    Jim Ord - 2012-10-22
    • status: pending --> open
     
  • Jim Ord

    Jim Ord - 2012-10-22

    I am using (via xampp) phpMyAdmin 3.3.9 and MySQL 5.5.8 - so I think I'll try to get xampp to upgrade and report back...

     
  • Marc Delisle

    Marc Delisle - 2012-10-22
    • status: open --> pending
     
  • Marc Delisle

    Marc Delisle - 2013-01-18
    • Status: pending --> closed