Re: length of columns names

Ph. Chantry wrote: > In IDS 9, the maximum length of columns names is 128 characters. It was 18 > in IDS 7. 9.20 and upwards, I believe. > The old limit of 18 characters seems to be compiled into old tools: having > defined one test colon with a name of 45 characters, I get the following > results: > > request: > select length(colname), colname from syscolumns ORDER BY 1 desc; > > - using ISQL 7.20.UD7, the result is false: > 45 ceci_est_une_colon That's puzzling; you are running that in the Query-Language menu? If you were somehow running from the INFO, then I'd not quibble; the code there would only provide 18 characters for the names (because that was the maximum length when the products were released), but in the main Query-Language option, there shouldn't be any way for it to get confused. It would take a lot more effort to be confused than to do the job right, shall we say. > - same false result with I4GL 7.20.UD7, R4GL 7.20.UD7 For this, you have to demonstrate with code what you are doing. > - using dbaccess 9.40, the result is true: > 45 ceci_est_une_colonne_de_plus_de_18_caracteres > > - same true result with JDBC 2.21.JC1 > > What do you thing about that ? One more reason to upgrade to ISQL 7.32 and I4GL 7.32 and ... > What are the more recent versions of the tools (isql, i4gl, r4gl) that > manage correctly the true length of syscolumns.colname ? 7.32. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/