Ignore case in query to SQL database

Question

I can't find a good example but if the name in the database is "namehascapsinit", It doesn't return anything. Is there anyway to ignore case?

String selection = MyTable.COL_NAME + " = ?";
                        String[] selectionArgs = new String[]{ "NameHasCapsInIt" };
                        c = getActivity().getContentResolver().query(MyTable.CONTENT_URI, null, selection, selectionArgs, null);

Thank in advance!

Not the downvoter, but if you search "sqlite ignore case" here, you probably didn't have to ask this question. http://stackoverflow.com/questions/15480319/case-sensitive-and-insensitive-like-in-sqlite — Andrew T., Jul 15 '14 at 07:02

score 7 · Accepted Answer · answered Jul 15 '14 at 07:33

7

Use this:

SELECT * FROM TableName WHERE col_name COLLATE NOCASE ="namehascapsinit"

answered Jul 15 '14 at 07:33

Phantômaxx

37,901
21
84
115

score 1 · Answer 2 · answered Jul 15 '14 at 06:43

1

You can write your code like this

("select * from TableName where col_name collate latin1_swedish_ci =?",String[] selectionArgs = new String[]{ "namehascapsinit" });

This is the example

select * from TableName where col_name collate latin1_swedish_ci ="namehascapsinit"

instead of latin1_swedish_ci you can use whatever collation you want

answered Jul 15 '14 at 06:43

Meghna

539
4
14

I'm getting errors "no such collation sequence: "latin1_swedish_ci" – DDukesterman Jul 15 '14 at 07:00

Ignore case in query to SQL database

2 Answers2