At 11:25 AM 6/08/2003 -0400, Ann wrote:

>In Firebird numeric and decimal map into exactly the same types. In the
>SQL-92 standard:
>
>16) For the <exact numeric type>s DECIMAL and NUMERIC:
> a) The maximum value of <precision> is implementation-defined.
><precision> shall not be
> greater than this value.
> b) The maximum value of <scale> is implementation-defined. <scale>
>shall not be greater than
> this maximum value.
>17) NUMERIC specifies the data type exact numeric, with the decimal
>precision and scale specified
> by the <precision> and <scale>.
>18) DECIMAL, specifies the data type exact numeric, with the decimal
>scale specified by the <scale>
> and the implementation-defined decimal precision equal to or
>greater than the value of the
> specified <precision>.

And that's it, and only it? Nothing about lower-scaled values being stored
differently according to whether they are declared numeric or decimal ???

Helen