Re: DATA TYPES

Posted in 1995

"Malcolm Weallans" — Fri, 6 Jan 1995 20:39:29 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? > I don't see any problem with using the SERIAL data type. In INFORMIX databases a serial datatype is stored as an integer - which is 4 bytes - and can take numbers in the range +or- 2billion! Malcolm Weallans Online Database Consultancy 2 Arkley Court Maidenhead Berks SL6 2YR Phone 0628-72154 Fax 0628-37463 CIX - onlinedbc