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
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