Do you ever need to do a case sensitive sort or search ? Any sort or search where case matters ? It's unusual to need to do this. If you don't need to do it, I recommend you put the collation in the column definition. This means that all WHERE clauses automatically respect what you think is significant.
<pre>CREATE TABLE Contacts (
familyname TEXT COLLATE NOCASE,
givenname TEXT COLLATE NOCASE,
homephone TEXT,
mobilephone TEXT
);</pre>