Re: Table Row Size

Posted in 1995

June Tong — 20 Mar 1995 12:43:41 GMT — source: Informix-list mailing list archive (1991-1998)

Diana Li <li@lfs.loral.com> wrote: >Does Informix use one extra byte for a column which allows null ? >there is an extra byte used for varchar type column but no extra byte >used for columns allow null. Informix does NOT use an extra byte for columns which allow nulls. The fact that nulls are allowed is stored in the syscolumns table as part of the column type, and nulls are stored as simply a special value of the data type. The extra byte on VARCHAR columns is the length of the VARCHAR. June ---- June Tong Informix Asia/Pacific ---- ---- On-Loan Engineer Singapore ---- ---- Location-du-jour: Bangkok ---- ---- junet@informix.com (65) 298-1716 ----