You should be using prepared statements. If that's not possible, then
escape the "'", for example:
INSERT INTO "this" VALUES ('Rootuser''s Desktop')
On Tue, 2010-03-02 at 12:51 -0600, Kavita Raghunathan wrote:
> I notice that when I try to insert the character “’” as part of a string into
> the sqlite database, my updates don’t work. Any ideas why? The same string
> without the “’” character works. I have not debugged to see where exactly in
> sqlite it fails.
>
> I’m inserting a text like this: “Rootuser’s desktop” does not work. “Rootuser
> desktop” works, the update to database suceeds and I’m able to view it using
> select.
>
> Regards,
> Kavita
> _______________________________________________
> 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
