On 2 Mar 2010, at 6:51pm, 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.
What API or toolkit are you using ? Have you tried executing the same command with the command-line tool ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
