title: Confused on SQL Sorting Built In Function for Case Sensitive Searches
body: <p>I'm trying to execute this statement on MYSQL. </p>
  
  <p><code>SELECT * FROM mydatabase.mytable where LASTNAME COLLATE Latin1_General_CS_AI like '%DOODLEBOP%'</code> </p>
  
  <p>I keep getting this error: 
  <code>Error Code: 1273. Unknown collation: 'Latin1_General_CS_AI'</code></p>
  
  <p>Any ideas what I am missing or doing wrong? I'm also trying to essentially mimic an article I was reading online. <a href="http://www.mytecbits.com/microsoft/sql-server/case-sensitive-string-comparison-on-sql-server" rel="nofollow">Case Sensitive Searching</a></p>
  
  <p>I tried a few quick Googles for the error and to no avail. Thanks</p>