Re: Escaping special characters in sql
| From: | Bob Bell | Date: | Thu, 11 Jul 2002 01:44:04 +0000 |
| Subject: | Re: Escaping special characters in sql | ||
| References: | 1 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-1845@lists.php.net to get a copy of this message | ||
On Wed, Jul 10, 2002 at 06:28:29PM -0500, William Lovaton <walovaton@yahoo.com.mx> wrote:
> I have a problem escaping special characters in the SQL's sentences... I
> inserted the next text in a database field: Giovanni's.
>
> In Mysql I got this: Giovanni\\\'s
> In Oracle I got this: Giovanni\'s
Are you using DB::quote()?
--
Bob Bell <bobbell@zk3.dec.com>
-------------------------------------------------------------------------
"Just don't create a file called -rf. :-)"
-- Larry Wall, creator of the Perl programming language