When I create a column and define it an INTEGER what is the range of values that I can use?

I am looking to store numbers > 10 gig   - will INTEGER do it?

Thanks!
Jeff

Jeff,

You have INTEGER which is 32 bit and BIGINT which is 64bit, (SMALLINT as well, which is 16bit).

16bit = 64,000
32bit = 4.3 billion
64bit = a very big number ... 4.3 billion x 4.3 billion.

I think BIGINT should do you.

I am not 100% sure whether there are operating system issues with this ... I guess you probably need to be running the 64 bit version of EDBSRVR.

Jeff


Its not just storing it, it also depends on what you intend to do with it. Whilst ElevateDB will happily cope with INTEGER and BIGINT even for 32 bit programs doing simple things like adding them together could blow up. If you don't intend mathematical operations I, personally, would go for VARCHAR or CHAR just to stop a moron trying to do so.

Roy Lambert

Adam,

<< I am not 100% sure whether there are operating system issues with this ... I guess you probably need to be running the 64 bit version of EDBSRVR. >>

No, that won't be required.  You can use the 32-bit or 64-bit versions of the EDB Server with BIGINT values without issue.  BIGINT values simply map to Int64 values in Delphi.

Tim Young
Elevate Software
www.elevatesoft.com