title: MySQL: Collate in query - any side effects?
body: <p>My <code>OpenCart</code> table collation is <code>utf8_bin</code>, unfortunately I can't search for product names with accent in their name. I searched on Google and just found that the collation must be <code>utf8_general_ci</code> for accent compatible and case insensitive search.</p>
  
  <p>What If I add collate declaration to the search query?</p>
  
  <pre><code>SELECT * 
  FROM  `address` 
  COLLATE utf8_general_ci
  LIMIT 0 , 30
  </code></pre>
  
  <p>Does it have any (bad) side effect? I red about problems with indexing, performance? Or it is totally safe?</p>