> which allows you to specify the precision. The main reason not to
> use money is that it is not completely standardized, i.e. there
> is no money type in the JDBC spec. Also, depending on your
> requirements, using numeric and a separate column to store the
> currency is more flexible when working with multiple currencies.
Dan didn't say it was an issue for him, but it may also be worth pointing
out that not all currencies have two decimal places. In one multicurrency
(banking) system in the past I stored all money amounts as integers (number
of "pennies") and scaled as appropriate. Painful though.
Nick
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
