I don't know if this will work for Oracle but try putting a backslash before the single quote mark (e.g. it\'s) the ' should then taken as another character by php. Hope this works for you. Hugh ----- Original Message ----- From: Kevin Dewsnup <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 30, 2001 4:31 PM Subject: [PHP] Problems inserting single quote into Oracle database
> 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 > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
