30.10.2014 11:14, castel.m@... 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