Subject | Re: [IBO] Numeric value changed by 0.01 using TwwIBOquery/TwwDBedit. |
---|---|
Author | Jason Wharton |
Post date | 2001-06-21T22:23:16Z |
> Numeric (13,2) consumes a 32 bit word in IB5 or lang level < 3.No, much less than that. Numeric( 9, x ) stays in a 32 bit ordinal type. If
you go over this InterBase maps it into a double precision column on the
server. Thus, you will potentially confront rounding issues.
> Max value an 32 integer can hold is +/-2147483647 or 10 digites.Jason Wharton
>
> Numeric (13,2) is a decimal integer, thus 123456789.22 can only
> be acurate to 10 digits or 123456789.2
>
> Try 923456789.2, a real mess :)
>
> IB6 , lang level >= 3 auto changes numberic (13,2) to (18,2) and of
> course now with a 64 bit integer word, larger values can be accurately
> represented.
CPS - Mesa AZ
http://www.ibobjects.com