Re: Identifiers max 18 character?

Magnus Lundgren wrote: > > Hi! > > I have an application running on Windows NT which uses a database that we > access through ODBC. With MS SQL Server and Oracle we have no major > problems. We are now trying to use Informix 7.30 but we fail because the > maximum length of the identifiers (table names, column names and index > names) is only 18 characters! > > Is there any way to bypass this problem? I don't want to rewrite my > application... > > Regards, > > Magnus Lundgren > Stockholm No. This is one of the (many) aspects of SQL-92 that Informix has not yet got around to implementing. We have to live with the old original SQL restriction on identifier length. -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 Mail: Peter.Lancashire.PL1@bayer.co.uk --- My Internet plumbing does not allow me to mail and post news together. Sorry. All opinions are my own and not those of Bayer plc. --- Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/