Re: 18 character/column limit

Cormac Burke wrote: } } I'm working with Informix 7.2, and we have some problems } with migrating an application due to the fact that Informix } limits column names to 18 characters (our users are used to } seeing descriptive names which require > 18 chars). Have } other users run into this problem, and does anyone have any } creative suggestions for workarounds? Thanks! } Cormac Burke } cormac@teleport.com } -- } cormac@teleport.COM Public Access User -- Not affiliated with Teleport } Public Access UNIX and Internet at (503) 220-1016 (2400-28800, N81) On the system I'm working on, we went to a hashing algorithm for table/column name generation, e.g. a colum named cost_recovery_category_code became ost_recv_cat_cd628 using a hash, but I wouldn't recommend it as remembering the physical names is a MAJOR PAIN. Carol Davies cdavies@csc.com