I usually use NUMERIC(18,2), and for values of inventory where amounts need
to be calculated as a percentage or a fraction, I use NUMERIC(18,4)

I.e. 1 tonne of peanuts is $450.3428 dollars. That way when someone buys
100grams, the accuracy is still l pretty good.

N.

> -----Original Message-----
> From: Grant Brown [mailto:grant@...]
> Sent: Thursday, 14 April 2005 3:52 PM
> To: Firbird Support Group
> Subject: [firebird-support] Currancy values in FireBird
>
>
> Hi all,
>
> Which data type is best used for currency values in FB 1.5
>
> --
> Regards,
> Grant Brown
>
> Product Development Manager
> Phone : 02 4229 1185
> Mobile : 0412 926 995
> Email : grant@...
> Web : www.sitedoc.com.au
>
> SiteDoc - Easy to Use - Powerful Results
>
> This email and any attached files (of whatsoever nature) are
> * confidential, may be privileged and intended solely for the
> use of the intended recipient
> * subject to copyright and the Privacy Act (Cth)
>
> Any confidentiality or privilege is not lost or waived
> because of any error in sending this email to you. If you
> have received this email in error, please advise by return
> email, delete it from your system and destroy any copies.
>
> Our company is not responsible for any viruses or harmful
> programs passed on down via email. You should have installed,
> up to date virus scanning software.
>
> The views expressed in this email are those of the sender and
> should not necessarily be taken as those of the company.
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
> __________ NOD32 1.1060 (20050414) Information __________
>
> This message was checked by NOD32 antivirus system.
> http://www.nod32.com
>
>