Re: Problems inserting single quote into Oracle database
| From: | David Robley | Date: | Wed, 31 Oct 2001 00:57:20 +0000 |
| Subject: | Re: Problems inserting single quote into Oracle database | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-72943@lists.php.net to get a copy of this message | ||
On Wed, 31 Oct 2001 11:01, Kevin Dewsnup wrote:
> I am having problems with inserting single quote's
> into an oracle 8.1.7 database through a form.
>
> When inserting 'its' it works fine.
>
> When inserting 'it's' I get this error:
> "OCIParse: ORA-01756: quoted string not properly
> terminated in blah..."
>
> So then I try 'it''s' (which works in SQL*Plus) I get
> this error:
> "OCIStmtExecute: ORA-00911: invalid character in
> blah..."
>
> Thank's in advance!
>
> -Kevin
Backslash works for mysql. Have a look at the addslashes (for putting
into Oracle) and stripslashes (for displaying data retrieved) functions,
also the magic_quotes settings in your php.ini.
--
David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc
CENTRE FOR INJURY STUDIES Flinders University, SOUTH AUSTRALIA
My lucky color just faded.