Oracle is case-sensitive by default when using the 'like' and '=' clauses, but MySQL is not by default. BioMart has no settings of its own that control this, and so in terms of case-sensitivity it will behave in whatever way the database it is using is configured to behave.
You can test your own database's behaviour by opening a database prompt (SQLPlus on oracle, or a MySQL command line for MySQL) and doing a couple of test SELECT queries using the '=' and 'LIKE' operators in the where clause and a variety of differently cased values. cheers, Richard On Fri, 2009-05-15 at 11:41 +0100, Rebecca Shepherd wrote: > Hi > > We have a gene name search box in our mart and the search is case > sensitive. We would like it to be case insensitive. Ensembl seem to have > a similar search which is case insensitive. I have had a look at the > settings for Ensembl in MartEditor and they seem to be the same as ours. > We are using an oracle database and they are using mysql. Could this > make a difference? > > Thanks > > Rebecca > > -- Richard Holland, BSc MBCS Finance Director, Eagle Genomics Ltd T: +44 (0)1223 654481 ext 3 | E: [email protected] http://www.eaglegenomics.com/
