Re: Whose limit is the 18 char identifier limit

Posted in 1999

Topics: Connectivity: ODBC / JDBC / .NET

Chuck Renaud — Mon, 5 Apr 1999 19:53:17 -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. Despite rumor, it has not been changed for 7.31...maybe for 7.32 if enough people complain about it.

↪ replying to Chuck Renaud

Seth Grimes — Mon, 05 Apr 1999 22:28:49 -0400 — source: Informix-list mailing list archive (1991-1998)

The limit for 9.1x, the current version, is NOT "upped to 128 characters." I don't know about 9.2. Seth Chuck Renaud wrote: > > > 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. > > Despite rumor, it has not been changed for 7.31...maybe for 7.32 if > enough people complain about it. -- Seth Grimes Alta Plana database & Web / design & development grimes@altaplana.com http://altaplana.com 301-891-2581

↪ replying to Seth Grimes

Eric Weaver — Thu, 8 Apr 1999 08:49:05 -0400 — source: Informix-list mailing list archive (1991-1998)

In 9.2 the 18 character identifier limit will finally be history! That is the migration path for 7.3x and 9.14 users, so eventually, everyone will be happy ;-) Seth Grimes wrote in message <37097161.B9548AEA@chele.cais.net>... >The limit for 9.1x, the current version, is NOT "upped to 128 characters." >I don't know about 9.2. > > Seth > >Chuck Renaud wrote: >> >> > 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. >> >> Despite rumor, it has not been changed for 7.31...maybe for 7.32 if >> enough people complain about it. > >-- >Seth Grimes Alta Plana database & Web / design & development >grimes@altaplana.com http://altaplana.com 301-891-2581