On 3/8/07, Ivan Prenosil <Ivan.Prenosil@...> wrote:
> >> But the algorithm is wrong anyway - it does allow changing
> >> 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?
>
> Yes.
> 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
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>


--
Erick Sasse