Good day, If you look in http://www.sqlite.org/capi3ref.html#sqlite3_bind_blob for the function
int sqlite3_bind_text(sqlite3_stmt*, int, const char*, int n, void(*)(void*)); This will allow you to bind any character into an SQL statement. There are other benefits to using this technique. regards, Adam On Tue, Mar 2, 2010 at 2:37 PM, Kavita Raghunathan < kavita.raghunat...@skyfiber.com> wrote: > 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 > -- VerifEye Technologies Inc. 905-948-0015x245 7100 Warden Ave, Unit 3 Markham ON, L3R 8B5 Canada _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
