It seems to works either way. I'm just wondering is there any hidden reason that single quote is preferred? Portability? Or is double-qoute has some kind of special meaning that we should use it for that special purpose?
-radzi- ----- Original Message ----- From: "P Kishor" <punk.k...@gmail.com> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Sent: Monday, December 15, 2008 1:32 PM Subject: Re: [sqlite] Adding data with periods > On 12/14/08, aditya siram <aditya.si...@gmail.com> wrote: >> Thanks a lot. The issue has been fixed with: >> INSERT INTO TEST_TABLE(CONTENTS) VALUES ("Hello. World!"); >> > > > Use single quotes to delimit text, not double quotes. > _______________________________________________ > 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