Currency Storage in Oracle with Delphi

From: Roger C. Morgan II <tmorgan3_at_tampabay.rr.com>
Date: Thu, 18 Nov 1999 05:53:36 GMT
Message-ID: <AvMY3.17120$435.61738@typhoon2.tampabay.rr.com>

We are in the process of converting from InterBase to Oracle to backend our Delphi applications. In designing the new Oracle database the question has come-up "How do we best store monetary values to prevent penny rounding issues?". We are in the financial industry so "penny balancing" is critical to many of our apps.

We are using BDE and intend to continue to use it for the near future. This means there could be type conversions between Delphi & BDE, then again between BDE & Oracle, just to write the data. This also means there would be similar conversions while reading the data. Creating potentially 4 datatype conversions just to write a value & read it back.

What datatypes (for Oracle and/or Delphi) would you suggest to maximize the accuracy in this environment.

Any comments or suggestions would be appreciated,

Roger Morgan
Roger_at_pathfindermail.com Received on Wed Nov 17 1999 - 23:53:36 CST