Re: DATA TYPES

Posted in 1995

"Andy Kent" — Fri, 6 Jan 1995 10:11:43 GMT — source: Informix-list mailing list archive (1991-1998)

> > Which data type is most suitable for serial numbers that you expect to > hit 100,000 and more in the course of at least 2 years. Integer is > definately out for a column data type since it will max out and roll > over at about 37600 something. You will get some interesting queries > there! :-) Any suggestions? > SMALLINT is limited to +/- 32767. INTEGER goes to +/- 2 billion. SERIAL is like an INTEGER except it optionally generates the numbers for you. If you need to go higher than that try FLOAT. akent@cix.compulink.co.uk (Andy Kent) -------------------------------------