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

Reply via email to