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?
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?