MySQL Case Sensitivity with BINARY VALUES
Posted on 2009-02-18
I have some binary data that i want to convert to lower or upper case to compare to a string.
SELECT myBinaryData FROM table_a WHERE myBinaryData Like "UPPERCASE";
The string in the where clause will be mixed case as will the binary data, i would like to know if it is possible to convert them both to either lower or uppercase to make the comparison.
LCASE() or UPPER() does not seem to work with binary data values, is there any other solution to this? (No points for telling me to change my data type to non binary)