--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...> wrote:

>
> At 01:18 PM 9/03/2008, you wrote:
> >I have a decimal (9,3) field in my database.
> >
> >On Windows with my ODBC client, when I save a value such as 120, it
> >gets stored as 120.0 by the Windows superserver.
> >Any ideas?
>
> No. But how are you determining how the number got stored? Is that

the result you see from an isql query? Or is it some third-party GUI
product?

>
> ./heLen
>

I was using Isql - and every value was being formatting to 3 decimal
places. So, I was storing .01 and I would see 1.000 instead. Same
with 1000, it would be stored as 1.000.

I have discovered that there is a bug in Wine that formats everything
passed as a decimal into scientific notation, and that's consistent
with what I'm seeing. It's to do with the Wine version of the windows
ecvt function.

Looks like my Linux port is dead in the water until the Wine
developers agree on a fix, and this bug has apparently been around for
some years now without an agreed fix. :(