Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

phpMyAdmin and float

Discussion in 'Database Discussion' started by MarlboroMan, Dec 28, 2001.

  1. MarlboroMan

    MarlboroMan Well-Known Member

    Dec 7, 2001
    Likes Received:
    Trophy Points:
    Was trying to familiarize myself with cpanel and what it does, managed to create myself a stock book table with ISBN, author, title, and price fields, using float(4,2) for the price type, to allow prices with two decimal places in them. When I was using phpMyAdmin to attempt to populate the table, the price field would not accept more than four characters total, ie 3.99. It would not take 29.99 as hard as I tried to make it. Thinking I must have screwed something up, I logged into the mySQL account from a shell prompt and attempted to put the value in the field with an INSERT statement, and that worked.

    So something in phpMyAdmin and float is slightly skewered. Is this a bug, or am I missing something here on how I should be inputting the value I want?
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice