Skip to content Skip to sidebar Skip to footer
Home / Collation / Sql / Sqlite

Sqlite Case Sensitive Search With Collate Nocase Field

Post a Comment
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 possib

Solution 1:

Just switch the collation back for that query:

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

Post a Comment for "Sqlite Case Sensitive Search With Collate Nocase Field"