Re: DB_common::quoteString() and OCI8
| From: | Thies C. Arntzen | Date: | Sat, 23 Dec 2000 21:39:26 +0000 |
| Subject: | Re: DB_common::quoteString() and OCI8 | ||
| References: | 1 2 | Groups: | php.pear |
| Request: | Send a blank email to php-pear+get-731@lists.php.net to get a copy of this message | ||
On Fri, Dec 22, 2000 at 02:46:46PM -0500, Chuck Hagenbuch wrote:
> Quoting "Daniel, Adam [EESUS]" <ADaniel1@EESUS.JNJ.com>:
>
> > If the quoteString() function is to be used to escape single quotes inside
> > an SQL query the way it is now won't work with Oracle. Oracle uses '' (2
> > single quotes) instead of \'.
>
> The correct way to fix this would be to put a quoteString() function into
> DB_oci8. Since DB_oci8 extends DB_common, this would override the quoting
> function correctly (assuming that you were using $dbconn->quoteString() instead
> of calling it statically). However, are you _sure_ that \' doesn't work in
> oracle? For some reason I thought it did...
sorry chuck - it doesn't
tc