Casse sensitive mysql search with Qt
I want to do a casse sensitive search in mysql syntax using Qt. I know that to do a casse sensitive mysql search you should do something like this:
SELECT * From GeoAndEnergies where SMILES='c1ccc(C2=NN=NC2=C2C=CC=CN2)nc1'
AND BINARY SMILES='c1ccc(C2=NN=NC2=C2C=CC=CN2)nc1';
I tryied to use the same syntax in Qt and it is not working at all, in the sense that the mysql crash.
Does anyone know what I should use?
Shouldn't you use
COLLATEfor that ?
In any case, what do you mean by crash ? The query fails or the application crashes ? If the former, did you check the error returned by QSqlQuery ?