For the record, MySQL *does* support case-sensitive matching. It's just not the default.
Adding case-sensitive matching is as simple as changing the default collation to latin1_swedish_cs instead of latin1_swedish_ci. Or utf8_general_cs instead of utf8_general_ci if the character set on the column in question is UTF8.
For the record, MySQL *does* support case-sensitive matching. It's just not the default.
Adding case-sensitive matching is as simple as changing the default collation to latin1_swedish_cs instead of latin1_swedish_ci. Or utf8_general_cs instead of utf8_general_ci if the character set on the column in question is UTF8.