Subject Re: Re[2]: [ib-support] Paradox/Float to Firebird/Numeric/Float ?
Author Valdir Stiebe Junior
> That's my doubt too. I do not know how paradox (or even the BDE)
> handle this. I would like to use the firebird datatype that has the
> most similar "handling" as Paradox-Float to avoid customers complaints
> about diferent results after the transition from Pdox to FB.

Hi Carlos. We had to convert a Paradox (dBase3) data to our Firebird/IBX
database.
We had problems because the old data was using something like numeric(10,2)
to currency and our database use (16,6). This generated a lot of rounding
problems. So we had to import the data using cast(old_field as
numeric(16,2)). This worked for us.

Valdir.