30.10.2014 11:14, caste...@titelive.be wrote: > > I try to figure out why i have a problem in my database since i convert > it from firebird 1.5 (dialect 1, no charset ) to firebird 2.5 (dialect 3 > and defined charset to utf8). > > The following SQL failed in the new database (fb 2.5 dialect 3). It > worked in fb 1.5 (dialect 1). > > cast(8975.00038147 as numeric(18,8)) / cast(1.06 as numeric(18,8))
In dialect 3: numeric(18, 8) / numeric(18, 8) = numeric(18, 16), i.e. only *two* decimal digits are left for the integral part. Obviously, 8466 (the result) do not fit there, hence the error. Dmitry