Ive been trying to make a query case sensitive in SQLite but cannot get it to tell the difference between "rv" and "Rv". For example:-
Select * from cars where `design` = 'rv';
Ive searched google and found loads of articles about making it insensitive so "rv" and "Rv" will return the same recordset, but dont know how to do it in reverse.
I did think of trying to change the values into either binary or hex (as obviously R and r will return different values) however cannot find any built in functions to do this.
I have also throught about returning the recordset, then using PHP to do the case comparison, but this seems a but overkill.
Any suggestions / ideas?