Re: Big bad bug in Online 7.2 UC2?

On 26 Jun 1997, Joseph Cullipher wrote: > 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. That formula may be close, but the exact calculations can be found in the _Informix Guide to SQL_, in the Data Types section (pp. 3-15ish for v7.1). In fact, you can't just use the collength -- doesn't this include the maximum and minimum as the high and low bytes (or vice versa)? Looks like it does to me. Wonder where the exact length /is/ stored...? -Richard