Sample Header Ad - 728x90

What are the various Informix column data types?

3 votes
2 answers
2002 views
I am writing a query where I need to know if a column is of the "BLOB" type of column. According to this documentation 41 is the number for "BLOB" types of columns, in general. However, when I query the syscolumns table I see that columns, which store BLOB data, actually have values of 297, in my case. That page linked above does not even have number "297" anywhere on its page. I found another page, titled "Data Type Constants" but here again, number "297" is not even present anywhere on the page. It appears that documentation's list of data types is not complete. Is there a (more) complete list of column types in Informix?
Asked by stopkillinggames.com (161 rep)
Apr 5, 2021, 02:33 PM
Last activity: May 4, 2022, 12:55 PM