Big bad bug in Online 7.2 UC2?

Posted in 1997

Dirk Fromhein — Wed, 25 Jun 1997 22:53:16 -0400 — source: Informix-list mailing list archive (1991-1998)

Using the sample stores7 database and the following SQL: select colname, coltype, collength from informix.syscolumns, informix.systables where informix.syscolumns.tabid = informix.systables.tabid and tabname = 'catalog' You get: colname coltype collength catalog_num 262 4 stock_num 257 2 manu_code 256 3 cat_descr 12 56 cat_picture 11 56 cat_advert 13 16895 Ummm... cat_advert is a varchar(255) why is the size 16895? Or am I just completely not understanding this? Thanks, Dirk Fromhein df@watershed.com