[ensembl-dev] Case-Sensitivity in Ensembl MySQL

PATERSON Trevor trevor.paterson at roslin.ed.ac.uk
Thu Jul 26 15:49:17 BST 2012

Could I get some information about whether case-sensitivity is ever used in Ensembl tables and queries?

As far as I can discover none of the queries in the Perl API enforce case sensitivity by specifying a COLLATION,

(i.e. if I grep the modules for occurrences of 'COLLATE')

.. so are all columns, in all tables  of  the schema treated as case-insensitive?

Or are there any particular columns specified as case-sensitive?

Until today I was blissfully unaware that MySQL's default behaviour for non-binary string searches is to be case-insensitive.



Trevor Paterson PhD
trevor.paterson at roslin.ed.ac.uk<mailto:trevor.paterson at roslin.ed.ac.uk>
The Roslin Institute
Royal (Dick) School of Veterinary Studies
University of Edinburgh
Easter Bush
EH25 9RG
Scotland UK

phone +44 (0)131 651 9157


Please consider the environment before printing this e-mail
The University of Edinburgh is a charitable body, registered in Scotland with registration number SC005336
Disclaimer:This e-mail and any attachments are confidential and intended solely for the use of the recipient(s) to whom they are addressed. If you have received it in error, please destroy all copies and inform the sender.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.ensembl.org/pipermail/dev_ensembl.org/attachments/20120726/a0499383/attachment.html>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: not available
URL: <http://mail.ensembl.org/pipermail/dev_ensembl.org/attachments/20120726/a0499383/attachment.ksh>

More information about the Dev mailing list