Question forwarded to the sqlite-users mailing list. Quick answer: String are quoted in SQL using single quotes, not double-quotes. What you are seeing is not a bug. You are misusing the string quoting mechanism.
On Oct 27, 2009, at 8:51 AM, Sergiu _ wrote: > Hello, > > I use SQLite in one of my projects for quite long time and it looked > to be a very good product. > Though, I think I spotted a bug, but I am not sure. Please confirm. > > Scenario: Create a table having at least one column of TEXT type > (let's say "myColumn"). Insert a row, having the value "STATUS" on > that TEXT column; Then try to select the row by using WHERE myColumn > = "STATUS". It does not work for me. > > Could you please tell me whether this is a bug or I am just using it > wrong ? > Thank you. > > Sergiu D. Richard Hipp d...@hwaci.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users