Re: DATA TYPES

Posted in 1995

Alan Popiel — 6 Jan 1995 11:33:18 -0500 — source: Informix-list mailing list archive (1991-1998)

> Subject: DATA TYPES > Date: 5 Jan 1995 15:50:46 GMT > Reply-To: rt@astro.ocis.temple.edu (rt@astro.ocis.temple.edu) > Organization: Temple University, Academic Computer Services > > 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? SERIAL values are four bytes in length, as are INTEGERs, so they support values in excess of 2 billion. It is SMALLINT values which are two bytes and max out at 32767. Regards, Alan +---------------------------+-----------------------------------------------+ | R. Alan Popiel | Internet: alan@den.mmc.com | | Martin Marietta, SLS | Voice: 303-977-9998 | | P.O. Box 179, M/S 3810 | Standard disclaimers apply. Cutesy ones, too. | | Denver, CO 80201-0179 USA | Your mileage may vary. Void where prohibited. | +---------------------------+-----------------------------------------------+