Whats the correct field type

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
Calimero
Forum Contributor
Posts: 310
Joined: Thu Jan 22, 2004 6:54 pm
Location: Milky Way

Whats the correct field type

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 !
User avatar
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
penguinboy
Forum Contributor
Posts: 171
Joined: Thu Nov 07, 2002 11:25 am

Post by penguinboy »

Post Reply