Re: identiers > 18 characters possible??

Posted in 1997

Mike Gallagher — Fri, 09 May 1997 09:10:54 -0400 — source: Informix-list mailing list archive (1991-1998)

Richard Stanford wrote: > > On 7 May 1997, Wellerding Andreas wrote: > > > Hi Informix specialists, > > > > Is it possible to use identifiers longer than 18 characters in Informix > > databases? > > Not in <=7.22 at any rate. System table constraints on tabname and colname Are later versions expected to allow more than 18 characters? > are still 18 characters. Some preprocessing might allow you to emulate > longer names if that's what you're looking for, though[0]. > > -Richard > > [0] <fx: sigh> My current company decided that five characters was the best > size for a table name. Now we have some really odd tables that nobody > really understands. 729 tables, 663 of which are 5 characters, 47 of > which are SHORTER. I really wish we had the opposite problem sometimes. -- Michael Gallagher Open Link Financial Email: mgallagh@olf.com Phone: (516) 227-6600 x212