Re: DB_common::quoteString() and OCI8
| From: | Chuck Hagenbuch | Date: | Fri, 22 Dec 2000 19:46:46 +0000 |
| Subject: | Re: DB_common::quoteString() and OCI8 | ||
| References: | 1 | Groups: | php.pear |
| Request: | Send a blank email to php-pear+get-730@lists.php.net to get a copy of this message | ||
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...
-chuck
--
Charles Hagenbuch, <chuck@horde.org>
"If you can't stand the heat, get out of the chicken!" - Baby Blues