What field type should I use for currency? (£)

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
mhouldridge
Forum Contributor
Posts: 267
Joined: Wed Jan 26, 2005 5:13 am

What field type should I use for currency? (£)

Post by mhouldridge »

Hi,

As in question. I am a newbie to mysql and do not know what to choose for currency, i.e INT, FLOAT, BIGINT.

I think it is the float one as this seems to accept decimals. Is this correct?

thanks in advance
User avatar
onion2k
Jedi Mod
Posts: 5263
Joined: Tue Dec 21, 2004 5:03 pm
Location: usrlab.com

Post by onion2k »

Generally I use a "decimal" field.
ckuipers
Forum Commoner
Posts: 61
Joined: Mon Mar 24, 2003 6:10 am

Post by ckuipers »

Same here, decimal
Post Reply