Single quotes are SQL, as chosen by he designers. It is good practice to stick to the standard rather than rely on extensions which vary from implementatiopn tio implementation.
Mohd Radzi Ibrahim wrote: > 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" <[email protected]> > To: "General Discussion of SQLite Database" <[email protected]> > Sent: Monday, December 15, 2008 1:32 PM > Subject: Re: [sqlite] Adding data with periods > > > >> On 12/14/08, aditya siram <[email protected]> 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 >> [email protected] >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> >> > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
