Simon and Gabriel, I'm using the C API, I'm inserting strings. One of the strings happens to have an "'" in it. I have to write extra code to parse the character and escape it, I'll do that if I have to. I have not tried the command line tool. I'll try it and get back to you.
Kavita On 3/2/10 12:56 PM, "Simon Slavin" <slav...@bigfraud.org> wrote: > > 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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
