Hi, Sqlite takes the period as a special character. Wherever you get a period ' make it as ''. This will make it as a normal character and will work fine. Hope the solution solves your problem.
Regards, Kirrthana -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]on Behalf Of aditya siram Sent: Monday, December 15, 2008 10:35 AM To: sqlite-users@sqlite.org 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 The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments contained in it. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
