Subject Re: [firebird-support] Any enhancement on Firebird 2.0 Numeric or Decimal DataType
Author Svein Erling Tysvaer
Do you need a precision of more than 18? I.e. are all digits
significant? Or are you asking because the content of a field may vary a
lot, e.g. you have a weight field, but the object in question may be an
hydrogen atom or the sun (actually, I don't know enough to tell whether
18 digits will be enough precision to cover both those cases, I just
suspect that it may not be enough ;o)?

If you need a precision greater than 18, then Firebird may not be
suitable for your requirements. If you need various scales rather than
precision, then I guess you could just add another field representing
the scale.


Chau Chee Yang wrote:
> Hi,
> Firebird 1.5 supports Numeric/Decimal up to precision of 19. Will
> that be enhanced in Firebird 2.0? MSSQL's numeric data type can
> support up to 38 precision.
> I have a field using 10 decimal points. If I use Numeric data type, I
> have 9 digits left in front of decimal points.
> Best Regards,
> Chau Chee Yang