Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
-
Calimero
- Forum Contributor
- Posts: 310
- Joined: Thu Jan 22, 2004 6:54 pm
- Location: Milky Way
Post
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 !
-
feyd
- Neighborhood Spidermoddy
- Posts: 31559
- Joined: Mon Mar 29, 2004 3:24 pm
- Location: Bothell, Washington, USA
Post
by feyd »
DECIMAL(8,2) or similar..
-
jtc970
- Forum Commoner
- Posts: 38
- Joined: Sun Jan 18, 2004 11:49 pm
Post
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