Re: Length of table/column names

Alex Molochnikov wrote: > > The Informix manual states that the maximum length of table and column > identifiers is 18 characters (apparently, this includes the NULL terminator > as well). Other databases (Sybase, MS SQL Server, Oracle) allow up to 30 > characters. > > Is the limit of 18 chars a rock-solid barrier, or is there some way (server > settings, environment variables etc.) to extend it? It is such a > straightjacket to cut everything down to 18 chars when the same app must > connect to Sybase and other databases that are more liberal in their > constraints. There is no null terminator. Anyhow, for now the 18 character limit is a hard limit. Version 7.31 is supposed to remove that restriction and allow 256 character identifiers so you can start posting to the other newsgroups about their names being to restrictive soon ;-) Art S. Kagel