RE: coltype

Posted in 2000

Demus, Alan — Thu, 4 May 2000 15:26:56 -0500 — source: Informix-list mailing list archive (1991-1998)

Unofficially, but this seems to work: 0 - char 1 - smallint 2 - integer 4 - smallfloat 5 - decimal 6 - serial 7 - date 8 - money 10 - datetime 11 - byte 12 - text 13 - varchar 14 - interval These are "Null Allowed" The value plus 256 indicates "Not Null" Other values are not so straighforward > -----Original Message----- > From: Roger Xu [SMTP:roger_xu@dp7uptx.com] > Sent: Thursday, May 04, 2000 2:37 PM > To: Informix-List (E-mail) > Cc: "'Roger Xu'"@iiug.iiug.org > Subject: coltype > > Hi, > > Can someone help me to interpret coltype in syscolumns system catalog > table. > I have coltype=0 > coltype=1 > coltype=2 > coltype=4 > coltype=5 > coltype=6 > coltype=7 > coltype=10 > coltype=11 > coltype=12 > coltype=256 > coltype=258 > coltype=259 > coltype=261 > coltype=262 > > Thanks > > > Roger XU > > Database Administrator > Dr Pepper Bottling Company of Texas > 2304 Century Center Blvd. > Irving, TX 75062 > > (972)721-8337