Re: DATA TYPES

Posted in 1995

Jonathan Leffler — 6 Jan 1995 11:58:07 -0500 — source: Informix-list mailing list archive (1991-1998)

>From: rt@astro.ocis.temple.edu (rt@astro.ocis.temple.edu) >Subject: DATA TYPES >Date: 5 Jan 1995 15:50:46 GMT >X-Informix-List-Id: <news.10595> >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 has a range of -2147483647 .. +2147483647 -- this would do. SMALLINT has a range of -32767 .. +32767. You could also consider the SERIAL type, which is a special case of INTEGER. >Integer is definitely out for a column data type since it will max out and >roll over at about 37600 something. This comment is bovine excrement. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>

Related threads

smallints
Error 908 from one instance to another