Re: Do you know the coltype converstion?

Posted in 1993

Dave Snyder — Sun, 24 Jan 1993 20:26:35 -0500 (EST) — source: Informix-list mailing list archive (1991-1998)

Quoting Reg Foulkes... } } I need to build a lookup table for coltype in syscolumns. Does anyone have } a list of the conversions? } } I know O is equivalent to Char and 256 is equivalent to Integer. Can anyone } help me fill in the blanks. } Here you go... and I believe 256 is really a CHAR that disallows NULL SQLCHAR 0 SQLSMINT 1 SQLINT 2 SQLFLOAT 3 SQLSMFLOAT 4 SQLDECIMAL 5 SQLSERIAL 6 SQLDATE 7 SQLMONEY 8 SQLNULL 9 SQLDTIME 10 SQLBYTES 11 SQLTEXT 12 SQLVCHAR 13 SQLINTERVAL 14 DAS -- David Snyder @ Snide Computer Services - Folcroft, PA Current Release is db4glgen-3.9 UUCP: ..!uunet!das13!dave INTERNET: dave.snyder@snide.com