Re: [PHP] Problems inserting single quote into Oracle database

2001-10-31 Thread Kevin Dewsnup
base from a form and the data looks good. Seems like Sybase and Oracle treat single quotes in a similar way. I wonder why there is no magic_quotes_oracle? -Kevin - Original Message - From: "David Robley" <[EMAIL PROTECTED]> To: "Kevin Dewsnup" <[EMAIL PROTECTE

[PHP] Problems inserting single quote into Oracle database

2001-10-30 Thread Kevin Dewsnup
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