The syntax is wrong. INSERT INTO TEST_TABLE(CONTENTS) VALUES ("Hello. World!");
is the correct one. -radzi- ----- Original Message ----- From: "aditya siram" <aditya.si...@gmail.com> To: <sqlite-users@sqlite.org> Sent: Monday, December 15, 2008 1:04 PM Subject: [sqlite] Adding data with periods > Hi all, > I'm having trouble adding data with period characters in it. I tries to > escape the period with a `'` but that didn' t seem to work. Here is an > example interaction: > > sqlite> create table test_table ("Contents" varchar); > sqlite> insert into test_table "hello . world"; > SQL error: near ""hello . world"": syntax error > sqlite> insert into test_table "hello '. world"; > SQL error: near ""hello '. world"": syntax error > > Thanks ... > deech > _______________________________________________ > 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