version 2.8.16 on Linux
schema create table nicks (id integer primary key , nick TEXT, last integer(5)); Contents sqlite> select * from nicks; 4|Her|99 5|Her|99 6|Her|99 7|Him|99 8|You|99 Query 1 (correct behavior) sqlite> select id,nick,last from nicks where nick = 'Nick'; sqlite> Query 2 (incorrect?) sqlite> select id,nick,last from nicks where nick = "Nick"; 4|Her|99 5|Her|99 6|Her|99 7|Him|99 8|You|99 Thanks