Re: Whose limit is the 18 char identifier limit

Posted in 1999

Chuck Renaud — Mon, 5 Apr 1999 23:28:07 -0500 — source: Informix-list mailing list archive (1991-1998)

> > > It appears that 18 is the maximum length that a table name and/or a > > > column identifier can be. Is this an ODBC limit, an InterSolv driver > > > limit, or is this an Informix Server limit? Is there anyway around > > > this limit? > > > > Informix limit. It's that way until the new ANSI standard is > > "official". > > However, the limit is upped to 128 characters in the 9.x versions. Okay, I jumped the gun here. It's 128 characters in 9.2, which I thought was out already. Sorry about that...I obviously don't use IUS much >sigh<