Igor, Yes, I did read it and feel a little silly in retrospect. I assumed, foolishly, that he was specifically mentioning using BLOBs instead of other types. That's why I was confused. I will continue to research this to find the most future-proof, secure, and efficient method. I thank you all for the assistance. You've been a great help :)
Regards, Kurt -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik Sent: Wednesday, December 16, 2009 11:32 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Escaping strings to be used in queries in C/C++ Kurt D. Knudsen <kknud...@zystemsgo.com> wrote: > Thanks for the prompt reply. It seems sqlite3_mprintf() is exactly > what > I was looking for. I do have to ask, though, what is the benefit of > using the blob binding? I have my tables defined either using VARCHARs > or TEXTs. I've never used the BLOB type before and am unsure of the > benefits of it. Even though the URL you were given contains the word "blob" in it, it's not (only, or primarily) about BLOBs. Have you actually followed it? Igor Tandetnik _______________________________________________ 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