Subject | Re: [Firebird-Architect] NUMERIC vs DECIMAL |
---|---|
Author | Ann Harrison |
Post date | 2003-08-06T15:25:29Z |
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>.
Regards,
Ann
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>.
Regards,
Ann