title: How to Configure MySQL to be Case Sensitive
body: <p>What are the commands to enable and disable case sensitivity by default for an entire database on a MySQL server? I'm aware of the <a href="http://dev.mysql.com/doc/refman/5.0/en/charset-collate.html" rel="noreferrer">COLLATE</a> statement, but it seems it's necessary to place this in every SQL statement that's run. Is there an option to set this globally?</p>