Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2002091

[PHP-DB] Help with special characters in Oracle 8i From: Eric John Seneca (nix <email protected>)
Date: 09/12/02

 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