Subject Re: [firebird-support] Currency
Author Helen Borrie
At 07:51 PM 17/01/2004 -0500, you wrote:

>So the question is, given an application using US dollars, is there any
>value to using numeric(9,2) instead of numeric(18,2)?

No. Numeric(9,2) will overflow on 10 million.

>And is numeric(x,2) correct for dollars?

Yes. It's exact decimal, so there are no extraneous zillionths floating
about. That said, keep your eyes on things that use exchange rates. These
are usually quoted as numeric(x,4) or numeric(x,5).

>Oh, and one last question - if there is no value to (9,2), is there any
>harm in changing that to (18,2) in existing applications?

Harm, no. You can store a (9,2) into an (18,2). Work, some. You'll have
to take care of existing view declarations (drop and recreate) and stored
procs and triggers that poke column values into numeric(9,2)
variables. (You can use RECREATE on these).