The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

phpMyAdmin and float

Discussion in 'Database Discussions' 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?

Share This Page