Help with special characters in Oracle 8i
| From: | Eric John Seneca | Date: | Thu, 12 Sep 2002 21:00:28 +0000 |
| Subject: | Help with special characters in Oracle 8i | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-21724@lists.php.net to get a copy of this message | ||
Hello All,
I am running PHP 4.2 with Oracle 8.1.7. I am trying execute the following statement.
insert into job_application values
(NULL,'Unix','Mobile','Alabama','http://www.google.com/search?q=php+insert+oracle+special+characters\&hl=en\&lr=\&ie=UTF-8\&oe=UTF-8\&start=30\&sa=N','12-SEP-02');
As you can see I am trying to insert a url into the database and it keeps dying on the special
characters in the url. I have tried executing the following command in SqlPlus( set escape \ ) and
this sql statement works from command line. I cannot make this work from my php script. Any insight
into this problem would be appreciated.
Eric Seneca