From sqlite-users  Mon Dec 15 06:01:00 2008
From: "Mohd Radzi Ibrahim" <mradzi () pc ! jaring ! my>
Date: Mon, 15 Dec 2008 06:01:00 +0000
To: sqlite-users
Subject: Re: [sqlite] Adding data with periods
Message-Id: <BA448FC1BD0A4B1B90A05799C37DD5F1 () internal ! imsglobal ! com>
X-MARC-Message: https://marc.info/?l=sqlite-users&m=122932088125103

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.kish@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.siram@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