Re: identiers > 18 characters possible??

>From: Ian Goddard <igoddard@netcomuk.co.uk> >Date: Sun, 11 May 1997 23:52:17 -0700 >X-Informix-List-Id: <news.37802> > >David Williams wrote: >> I thought the the ANSI (SQL-92?) standard defines a maximum of 18 >> characters for table/column names? > >I thought so too, last time we covered this. Someone (possibly johnl) >said that this has been removed from later versions of ANSI - but >changing the engine to take advantage can't be easy. Actually, the SQL-86 and SQL-89 standards specify that a conforming implementation does not have to support names longer than 18 characters, but that it may do so. SQL-92 has 3 levels. SQL-89 more or less corresponds to the entry level. As far as I know, at the entry level, 18 character names are 'OK'. At higher levels, the names have to be up to 128 characters long. Informix claims compliance to entry level SQl-92 only. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>