Re: char to numeric

On 3/2/07, Buck <kc2hiz@xxxxxxxxx> wrote:

[ ... snip ... ]

> I don't believe a 10i 0 can hold value
 > of 9999999999 (I'm too lazy to check).

Yes, this is exactly why worrying about the optimisation _before_
getting the code to work to specification can be so dangerous.  If it
turns out that your program requires all 10 digits (or even 31!) then a
conversion to integer does no good, no matter how fast it is. <grin>

Again, this isn't intended as a criticism of your particular
circumstances.  It's more for the archives...  And by the bye, your
recollection is correct.  Although defined as 10i 0, the integer data
type cannot hold 10 nines.
  --buck

A 10i0 field isn't really 10i0; it is a four-byte binary field implementing
negative numbers with two's complement, which means -2147483678
to 2147483677.

While binary fields seem to have fallen out of vogue, it always helps to
know what the underlying implementation of the datum is.

Chris "nitpickin'" Pando
--
chris@xxxxxxxxx           | If I had a nickel I'd find a game
www.pando.org             | If I won a dollar I'd make it rain
                         | If it rained an ocean I'd drink it dry
                         | And lay me down dissatisified
--