Problems inserting single quote into Oracle database
| From: | Kevin Dewsnup | Date: | Wed, 31 Oct 2001 00:31:32 +0000 |
| Subject: | Problems inserting single quote into Oracle database | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-72938@lists.php.net to get a copy of this message | ||
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
__________________________________________________
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com