Change the currency fields to DOUBLE temporarily, then change the currency settings, then change the fields back to currency. I had to do this in a db where currency was set to 5 decimals once upon a time.

Albert

Dan Goldberg wrote:
I need to change the subunit digits from the normal two digits to four
digits.

The problem I have is when I change all my numbers shift over.

Example

10.99 is now .1099

How can I keep the decimal in the same place without having to multiple the
numbers in all the tables?
Dan Goldberg



Reply via email to