[sqlite] Possible bug

Is this a bug or something I'm missing with the logical handling of '' versus "" 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 beha

Re: [sqlite] Possible bug

Thanks. Thats what I thought but wanted to be sure. On Fri, 11 Nov 2005, Guillaume MAISON wrote: Tenkawa a écrit : Query 1 (correct behavior) sqlite> select id,nick,last from nicks where nick = 'Nick'; sqlite> Query 2 (incorrect?) sqlite> select id,nick,last fr