Re: Big bad bug in Online 7.2 UC2?

Dirk, Since this is a varchar column the collength is not represenitive of the actual size. The same also applies to decimal,datetime and others. To determine the size is pretty simple. (collength/256)+(collength mod 256) This formula will work for varchar,float,smallfloat,money and decimal. There is also some information about this in the faq i believe. HTH Joseph ------------------------------------------------------------------------- Joseph Cullipher |E-mail: joseph@cannonexpress.com PO Box 364 |opinions express are those of my own and Springdale, AR 72764 USA |don't necessarily reflect those of my company ------------------------------------------------------------------------- On Wed, 25 Jun 1997, Dirk Fromhein wrote: } 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 }