Case-Sensitive Search in SQL: Which Function to Use?

B. Binary

The BINARY function in SQL is used to perform case-sensitive searches. It compares strings based on their exact character values, taking into account uppercase and lowercase letters. This ensures that only records matching the search criteria with the same case are retrieved. For example, searching for 'Apple' using BINARY will only return results where the data is stored as 'Apple' and not 'apple' or 'APPLE'.