Page 1 of 1

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

Posted: Thu May 26, 2005 2:59 am
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

Posted: Thu May 26, 2005 3:14 am
by onion2k
Generally I use a "decimal" field.

Posted: Fri May 27, 2005 8:56 am
by ckuipers
Same here, decimal