[DB-SIG] BLOB data types ... API function

Andy Dustman farcepest at gmail.com
Sat Jan 1 17:29:52 CET 2005


On Sat, 1 Jan 2005 16:15:08 -0000, Peter Mott <peter at monicol.co.uk> wrote:
> >
> > Andy Dustman wrote:
> > > On Fri, 31 Dec 2004 18:53:52 -0800, Robert Brewer <fumanchu at amor.org>
> > > No. With MySQL, at least, the only meta-characters it cares about in
> > > strings passed to it are single-quote ('), backslash (\), and NUL
> > > (zero-byte), and all of these can be escaped with backslash, and there
> > > is an API function to do this safely.
> 
> That's nice. What is this API function?

mysql_real_escape(). It's a MySQL API function., and if you're using
MySQLdb, it's used internally; end-users never need to call it.
-- 
Computer interfaces should never be made of meat.

Using GMail? Setting Reply-to address to <> disables this annoying feature.


More information about the DB-SIG mailing list