Re: What is max. column name size?

Posted in 1997

Bill Ennis — 3 Apr 1997 10:53:11 -0500 — source: Informix-list mailing list archive (1991-1998)

> > Greetings everyone, > > I've got a couple really basic questions about Informix that I'd like to > know for comparison with Oracle and DB2. Thanks in advance for your > consideration. > > 1. When naming columns: > > A. How long can names be? 18 is ANSI standard 18 for Informix 30 for Oracle ? DB2 > B. What characters can be used (any special characters illegal) ? Don't know off hand > > 2. What data types does Informix support? I'm talking standard builtin > data types here - user defined or datablade. CHAR SMALLINT INTEGER DECIMAL SERIAL DATE MONEY DATETIME BYTE TEXT VARCHAR NCHAR NVARCHAR INTERVAL > > Thanks much, > > ------------ > Michael Burr Boeing Commercial Airplane Group 6-6F43, M/S 20-16 > Email: michael.n.burr@boeing.com -- Bill Ennis Voice: 312-474-7516 SSA Fax: 312-474-7460 500 W. Madison email: ennis@ssax.com ennis@accesschicago.net