* Jean-Pierre Schwickerath
> I'm trying to write some kind of small accounting software and I got
> stuck with the problem that doing a SUM() on values of a DECIMAL(7,2)
> row did show problems with (relatively) small values (like 173.58). I
> found a message explaining that mysql uses doubles inte
I am guessing that you are trying to find a MySQL data type of "Currency",
which does not exist.
I generally use a column that is DECIMAL(150,2) for US currency.
--Scott
At 01:32 PM 10/2/2003, Fabio Bernardo wrote:
I´m having some problems with currency´s fields. Actually I dont know what
mys
At 17:32 -0300 10/2/03, Fabio Bernardo wrote:
I´m having some problems with currency´s fields. Actually I dont know what
mysql´s field typeI have to choose..^
I wanna input this value: U$32.00 but, when I write the query: Select
'field' from table it returns..
'32' and not 32.00.
Wh
this is a php question, try:
http://www.php.net/manual/en/function.number-format.php
> Hi,
>
> I just want to know if mysql can set the output of a certain currency to
> this pattern :
>
> $1,500.00
>
> If I use a comma on a certain amount then I add it up to another amount with
> a comma I ge
;Mike(mickako)Blezien" <[EMAIL PROTECTED]>
>>Reply-To: [EMAIL PROTECTED]
>>To: Desmond Lee <[EMAIL PROTECTED]>
>>CC: [EMAIL PROTECTED]
>>Subject: Re: currency type
>>Date: Tue, 30 Jul 2002 11:36:30 -0500
>>
>>>>Desmond Lee wrote:
>>&g
quot; <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Desmond Lee <[EMAIL PROTECTED]>
>CC: [EMAIL PROTECTED]
>Subject: Re: currency type
>Date: Tue, 30 Jul 2002 11:36:30 -0500
>
> >>Desmond Lee wrote:
> >
> > Hi there
> >
> > Does mysq
>>Desmond Lee wrote:
>
> Hi there
>
> Does mysql have a currency type, or is it best to just use a varchar or a
> float?
>
> Thanks
>
> Desmond
I normally use the DECIMAL(6,2) data type, works very for currency values.
--
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder R
Saqib Shaikh writes:
> I'm interested to know what data type people consider suitable for storing
> currency.
As far as I know, the way to do it is to store the number of
the smallest possible unit as an integer of some sort. You'll
never run into any odd floating point-to-decimal conversion
pr
