Re: Oracle problem
| From: | .: B i g D o g :. | Date: | Wed, 16 Oct 2002 16:54:07 +0000 |
| Subject: | Re: Oracle problem | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-22461@lists.php.net to get a copy of this message | ||
You might want to play with the magic_qoutes...
On Wed, 2002-10-16 at 01:50, N.A.Morgan@bton.ac.uk wrote:
> Hi,
>
> Has anyone out there using PHP and Oracle come across this problem? I have
> a text area that allows free-form text that I store in a varchar2 column. I
> have problems with apostrophes in the free-form text. When users put in an
> apostrophe the SQL fails. If I force 3 apostrophes (the usual Oracle method
> of embedding apostrophes) the SQL fails. The only way to get round the
> problem is to strip them out (which I consider a work-around not a fix).
>
> Can anyone help?
>
> Neil Morgan
> Admin Computing Section
> University of Brighton
> Tel: +44 (0) 1273 64 3930
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--
.: B i g D o g :.