Single Quotes in Oracle Queries
| From: | Richard Crawford | Date: | Wed, 11 Apr 2001 18:04:39 +0000 |
| Subject: | Single Quotes in Oracle Queries | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-48188@lists.php.net to get a copy of this message | ||
Before we go about writing new functions to handle single quotes for our
Phorum reengineering project, I need to know if there is a way for PHP to
easily handle the issue of passing strings to a PL/SQL script, which
requires that single quotes be doubled up: that "I don't know" is
properly translated into "I don''t know". In my dreams, this is handled
by OCIParse or even OCIExecute, but I have a sinking feeling that this
isn't the case, and that we'll need to do an extra parsing step for all
of our strings that are inserted into the database, just for single
quotes.
Help!
Richard