Android SQLite Ignore Case from Database

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 😀

, , ,
Previous Post
Android Gallery with Dots On Scroll
Next Post
Android SSL self signed certificate pass by

Related Posts

Menu