Don't many financial transactions in US dollars get stored as integers anyway? The number of pennies, in other words.

Then just convert to dollars with a decimal place when needing to display, etc.

I recall this being pretty normal regardless of what database you use.