SQLite case sensitive search with collate nocase field

collation, sql, sqlite

Solution

Just switch the collation back for that query:

SELECT * FROM MyTable WHERE name COLLATE BINARY = 'Nick'

Problem

I have a database (which I cant change) that has a collate nocase field: ``` name string collate nocase ``` I need to do a search on this field that is case sensitive. Is this possible with the 'collate nocase'? Thanks

Original source