Subject | Re: [firebird-support] Changing numeric domain precision and scale |
---|---|
Author | Ivan Prenosil |
Post date | 2007-03-08T18:01:26Z |
>> But the algorithm is wrong anyway - it does allow changingYes.
>> NUMERIC(4,2) field to NUMERIC(4,3), which CAN corrupt the db.
>> (try it with value 99.99)
>
> So is my change from NUMERIC(18,4) to NUMERIC(15,2) safe?
Both types use BIGINT as storage type, and the change will cause
the old values be divided by 100, so they will always fit.
Ivan