Haris Papadopoulos wrote:

> Hi,
> The problem has to do with the value of a column of type Numeric(13,x)
> (where x=2 or 4 for me) fetched by a Select statement.
>
> I used:
> ---------
> 1) DbVisualizer 3.1
> 2) FirebirdSQL-RC2
> 3) Firebird SS-1.0.0 (Linux) or Interbase 6.0 Classic (Linux)
>
> I executed:
> ----------------
> 1) update product set prdPrice=24.84 where prdId='0047'
> /* Statement executed OK */
>
> 2) select prdId, prdPrice from product where prdId='0047'
> /* Statement executed OK */
>
> For column prdPrice I get the value:
> 24.839999999999999857891452847979962825775146484375
>
> I 've checked that the value is updated correctly but not fetched
> correctly by the driver.
> I 've tested Interclient and the value is fetched correctly.
> Note that other values (eg. 24.75 or 24.00) are fetched correctly.
> Note also that the problem initially appeared in my web-app.
>

How about dialect? (should be 3 for true numeric datatype)

Andrew