Re: Do you know the coltype converstion?

Posted in 1993

David Cortesi — 27 Jan 93 17:21:54 GMT — source: Informix-list mailing list archive (1991-1998)

In article <riskit-240193081954@47.201.0.36> riskit@x400gate.bnr.ca (Reg Foulkes) writes: >I need to build a lookup table for coltype in syscolumns. Does anyone have >a list of the conversions? >On my system if we do: > > Select coltype from syscolumns > where tabid = "some number"> >I will get a list of numbers ... These are documented quite clearly in chapter 2 of the Informix Guide to SQL: Reference. Look up the description of Syscolumns. The coltype value is not a simple integer mapping; there are meanings to some of the bits as well.