Subject | Re: [firebird-support] Decimal woes |
---|---|
Author | Helen Borrie |
Post date | 2008-03-09T07:31:55Z |
At 01:18 PM 9/03/2008, you wrote:
./heLen
>I have a decimal (9,3) field in my database.Actually, it gets stored as 120000. The RDB$FIELD_SCALE value in the domain definition record (RDB$FIELDS) says how many of the rightmost digits should follow the decimal point. If you see "120.0" it is your driver, or some element of your user interface software, that decides how to deal with those trailing zeroes for display.
>
>On Windows with my ODBC client, when I save a value such as 120, it
>gets stored as 120.0 by the Windows superserver.
>But when I use my Windows ODBC client with a Linux superserver, itNo. 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?
>stores the same value as 1.2 ! The Window ODBC client is using Wine.
>
>Any ideas?
./heLen