<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-GB link=blue vlink=purple><div class=WordSection1><p class=MsoNormal>Could I get some information about whether case-sensitivity is ever used in Ensembl tables and queries?<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>As far as I can discover none of the queries in the Perl API enforce case sensitivity by specifying a COLLATION,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>(i.e. if I grep the modules for occurrences of ‘COLLATE’)<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>.. so are all columns, in all tables of the schema treated as case-insensitive?<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Or are there any particular columns specified as case-sensitive?<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Until today I was blissfully unaware that MySQL’s default behaviour for non-binary string searches is to be case-insensitive. <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>cheers <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>trevor<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><b><span style='font-size:12.0pt;font-family:"Arial","sans-serif";color:navy;mso-fareast-language:EN-GB'>Trevor Paterson PhD<br></span></b><span style='font-size:12.0pt;font-family:"Arial","sans-serif";color:navy;mso-fareast-language:EN-GB'><a href="mailto:trevor.paterson@roslin.ed.ac.uk"><span style='color:blue'>trevor.paterson@roslin.ed.ac.uk</span></a></span><span style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-GB'><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:12.0pt;font-family:"Arial","sans-serif";color:navy;mso-fareast-language:EN-GB'>Bioinformatics <br>The Roslin Institute<br>Royal (Dick) School of Veterinary Studies<br>University of Edinburgh<br>Easter Bush<br>Midlothian<br>EH25 9RG<br>Scotland UK<br><br>phone +44 (0)131 651 9157<br><br><a href="http://bioinformatics.roslin.ed.ac.uk/"><span style='color:blue'>http://bioinformatics.roslin.ed.ac.uk/</span></a></span><span style='font-size:12.0pt;font-family:"Times New Roman","serif";color:black;mso-fareast-language:EN-GB'><br></span><span style='font-size:10.0pt;font-family:"Times New Roman","serif";color:navy;mso-fareast-language:EN-GB'><br></span><span style='font-size:12.0pt;font-family:"Arial","sans-serif";color:green;mso-fareast-language:EN-GB'>Please consider the environment before printing this e-mail</span><span style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-GB'><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><i><span style='font-size:10.0pt;font-family:"Times New Roman","serif";color:navy;mso-fareast-language:EN-GB'>The University of Edinburgh is a charitable body, registered in Scotland with registration number SC005336</span></i><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:navy;mso-fareast-language:EN-GB'><br><b>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.</b></span><span style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-GB'> <o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>