Re: Case sensitivity

On Mon, 14 Sep 1998, Greg Silverman wrote: > We seem to have a problem with case sensitivity in table names, in that > if we have caps in the table name (or an underscore even) we have > problems either dropping or modifying the name (gives a tablename cannot > be found error). * Which version(s) of which Informix product(s)? -- lower down you say SE on Linux, so presumably 7.24.UC5. * Are you running with DELIMIDENT set in the environment? * Are you using MODE ANSI databases? * Which programs are you using to access the database? > We have also noticed that caps do not work in field names either > (underscores work fine). > > Is this a "feature" of Informix? Not normally; you have to go out of your way to run into problems. Specifically, you can run into problems if you are careless with how you handle owner names, or with any sort of database where you use delimited identifiers (DELIMIDENT set in the environment). Otherwise, you should find everything pretty much case insensitive. > Is there a workaround (we've got a LOT of Access tables that have field > names with caps in them that we need to convert over to Informix...). > We're using latest version of SE for Linux... The other issue to be aware of is the 18-character limit on table names and column names... Yours, Jonathan Leffler (jleffler@informix.com) #include <witticism.h> Guardian of DBD::Informix v0.60 -- http://www.perl.com/CPAN Informix IDN for D4GL & Linux -- http://www.informix.com/idn