Hello mysql users: Would appreciate some advice on data types for a column. The value for the field would be a number that would never exceed 1000 but would have two decimal points limited to .25 increments e.g 5.25 or 7.75
There may be some simple calculations such as totals etc. What would be the appropriate data type, float(single precision), double, decimal etc. Of course accuracy in the calculations is important, but I assume double data type is overkill. Thanks -=Bryan=- --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
