Re: Case sensitivity

We have Informix-SE 7.24 for Linux and dbaccess to access the server. We are usin ANSI complient databases. We are not using DELIMITENT. The names that we are having problems with are shorter than 18 characters. Jonathan Leffler wrote: > 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