| Subject | Re: Decimal woes |
|---|---|
| Author | Graham |
| Post date | 2008-03-10T08:26:28Z |
--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...> wrote:
rightmost digits should follow the decimal point. If you see "120.0"
your book today, and it mentioned that I should be using float for
values which are data ( in this biological data ), and which is not
going to be manipulated mathematically.
However, it's a little curious that wine is pulling data out correctly
and just not storing it correctly.
>the domain definition record (RDB$FIELDS) says how many of the
> 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.
>
> Actually, it gets stored as 120000. The RDB$FIELD_SCALE value in
rightmost digits should follow the decimal point. If you see "120.0"
> ./heLenNot that it's going to help this particular problem, but I was reading
>
your book today, and it mentioned that I should be using float for
values which are data ( in this biological data ), and which is not
going to be manipulated mathematically.
However, it's a little curious that wine is pulling data out correctly
and just not storing it correctly.