Re: Any no. of fields limit in Informix Tables or programs?

Posted in 1994

Andrey Yu. Grachyov — Thu, 14 Apr 1994 13:23:58 +0400 — source: Informix-list mailing list archive (1991-1998)

> I would like to know if anyone has experience or knowledge or Informix > having a certain limit on the number of fields in the tables creation > or programming aspect. Also, is there a limit on the total byte size > of all the fields combined? ...skipped.... > Davin Boo Hi, Davin! I know the limits for Informix OnLine 5.0x: Maximum number of rows per table 4.278 billion Maximum number of columns per table 32767 Maximum number of special (VARCHAR, BLOB) columns per table 241 Maximum length of a row 32KB Maximum size of a table (excluding BLOBs) 33.822 billion bytes. Information source: Informix OnLine Version 5.0x/For the Unix OS Technical Brief Best regards. --------------------------------------------------------------- Andrew Yu. Grachyov | Phone +7 (095) 928-6078 TERN, Moscow, Russia | +7 (095) 925-1785 andy@tern.msk.su | Fax +7 (095) 280-3870