> Any pointers of how to go about converting Firebird1.5 database with
> Dialect1 to Firebird2.0 database with Dialect3?
>
> I need to keep the Numeric(18,2) as Numeric(18,2)
>
> If I backup in Firebird1.5, then restore in Firebird2.0, then all
> Numeric(18,2) change to Integer fields, but still handle data correctly.
>
> However newly created integer fields don't hold nr's like 5.26, they round
> them off to 5.

Numeric(18,2) in Dialect-1 is stored as Double Precision,
and changing db to Dialect-3 will not change it,
i.e. fields created under dialect-1 will remain Double Precision,
newly created fields (under dialect-3) will be stored as scaled Bigint.

Ivan
http://www.volny.cz/iprenosil/interbase/