dimanche 6 décembre 2015

Android SQLite case sensitive look-up

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