I am trying to use a cursor in Android to do a case sensitive lookup of my SQLite table. I have googled for it but all results are of people asking on how to get case insensitive lookup and tutorials on how to make it case-insensitive. That is the opposite of what I want. I want a case sensitive look-up, but I am still learning SQLite and don't know what to add.
This is how my cursor is currently called:
c = getContentResolver().query(element, null, PeriodicTable.SYMBOL + " LIKE? ", new String[]{guess}, "symbol");
Elements in the periodic table are case sensitive, so if you enter CO, you get Carbon and Oxygen. If you enter Co, you get Cobalt. I want to use case sensitivity to filter out erroneous user entries.
Aucun commentaire:
Enregistrer un commentaire