Subject Re: [firebird-support] Silent change of types?
Author Ivan Prenosil
> I have a problem!
> I wrote a script which declares a SP with an output parameter numeric(17,4). After I run that script, I saw this SP
> with the proper body, but with numeric(15,4).
>
> I use WinXP, FB1.5.3 SuperServer, Dialect 1.

Dialect 1 does not support "real" numeric type, instead it internally use double precision.
For display purposes is stores (in system tables) scale, but no precision.

Ivan