MySQL Forums
Forum List  »  Newbie

Decimal fields in tables
Posted by: fio productions
Date: February 16, 2012 01:57PM

Hi,
I have a database table which has 3 decimal(8,2) fields, 'price', 'tax'and 'total'. they receive their values,
from input fields in a form.

The decimals are all messed up when I put a number like 100.000 .
I understand that in order for me to have 3 floats I had to create the
db field type something like 'decimal(8,3)' ?

My question is: How to make a decimal field accept any number of floats, if it's '10.45' or '100.000' ?

Thanks in advance,
Mike

Options: ReplyQuote


Subject
Written By
Posted
Decimal fields in tables
February 16, 2012 01:57PM
February 16, 2012 02:36PM
February 16, 2012 02:16PM
February 16, 2012 08:41PM
February 17, 2012 07:53AM
February 17, 2012 11:18AM
February 17, 2012 09:09AM
February 17, 2012 05:58PM
February 18, 2012 02:41AM
February 18, 2012 10:04AM
February 18, 2012 11:00AM
February 18, 2012 12:14PM
February 18, 2012 04:28PM
February 18, 2012 10:53AM
February 18, 2012 06:16PM
February 18, 2012 07:20PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.