Sql uses a single quote or a tick mark to delimit strings. C, C++ and other languages use Dobule quote to delimit strings.
I think though that the column names may be double quoted to differentiate them from data. --- On Tue, 10/27/09, D. Richard Hipp <d...@hwaci.com> wrote: > From: D. Richard Hipp <d...@hwaci.com> > Subject: Re: [sqlite] SQLite: question > To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> > Cc: "Sergiu _" <sergiu...@gmail.com> > Date: Tuesday, October 27, 2009, 7:56 AM > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users