Re: Naming Standards

Lynda and Mike Dunham-Wilkie <lynmik@bc.sympatico.ca> wrote: :Dale Forrey wrote: :> :> We are new to the Informix world and the Data Administrator at our :> shop is a little frustrated with the 18 character limit on names. : :We're Illustra users and are about to consider porting our databases and :software to the Universal Server. Illustra allows very long table/ :column/index etc. names and is also case-sensitive. Why on earth have they repeated one of the bad features of some languages and made names case sensitive? I sure hope they have done away with that in the Universal Server. The reason this is bad is of course that it is all to easy to make mistakes if mixed case is used and in some cases such mistakes may be hard to find, or at least involve work that shouldn't be necessary. : Does the Universal :Server impose a 18-character limit on names? If so, does anyone have :advice on porting Illustra applications to the Universal Server? Allowing longer names than 18 characters is ok, but using them is doubtfull except possibly for some very special cases. If you have used them extensively you have a problem, but it should be possible to solve with proper editing tools replacing such long names with shorter ones. Of course I realize the work involved, and something that is a significant discomfort to do. Universal Server hopefully allows longer names for this reason. :Thanks,... Mike Dunham-Wilkie Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org