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! Yes and no. Yes we came across this problem migrating an SQL-Server system to Informix. And no, there is no workaround, except reduce the length of names. That's the wonderful thing about ANSI standards.... there are SO many to choose from. :-) Cheers, -- Mark. +-------------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | The Informix FAQ is at http://www.iiug.org | |mailto:marks@west.co.za +------------------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work... force it! | |Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! | |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+------------------------------------------------+