Page 1 of 1

Whats the correct field type

Posted: Mon Jul 26, 2004 2:07 pm
by Calimero
I need to insert this numbers 25.78 and 89.90 for ex.

I tried integer but no way it to work.

Is the float right type, if not please just tip me.

Thanks ahead !

Posted: Mon Jul 26, 2004 2:13 pm
by feyd
DECIMAL(8,2) or similar..

Posted: Mon Jul 26, 2004 2:15 pm
by jtc970
I beleive it's type
ex:
decimal(3,2)
allows -999.99 to 999.99

decimal(4,1)
allows -9999.9 to 9999.9

Posted: Mon Jul 26, 2004 5:33 pm
by penguinboy