Android SQLite Ignore Case from Database

If you want to select data from Database and you want to ignore the case of letters you should use COLLATE NOCASE in your query:

“SELECT * FROM  myDataBaseName WHERE some_column= some_value COLLATE NOCASE

It’s not exactly an android issue but you might need some day in your android projects, so I hope it helps :D

Exit mobile version