For some reason I was under the impression that MySQL searches were case-sensitive unless the "LIKE" syntax was used, but now it appears I was mistaken:

http://www.mysql.com/...ase_sensitivity.html

According to that page, a column needs to be set as "binary" for it to use case-sensitive searching. I understand how to set a column as binary, but I don't really know what it means (other than this narrow issue of case-sensitivity). Does it have any purpose beyond this specific issue?

Thanks in advance.

---

Fractured Atlas :: Liberate the Artist
Services: Healthcare, Fiscal Sponsorship, Marketing, Education, The Emerging Artists Fund