Re: Having trouble with inserting strings into Oracle8i viaphp

Rasmus Lerdorf wrote: > > > Having trouble with inserting strings into Oracle8i via php. > > If a string has an apostrophe I get errors, how do I insert a string > > with single quotes/apostrophe into oracle via PHP? > > Turn on magic_quotes_sybase > > Then either turn on magic_quotes_gpc or call AddSlashes() manually on any > strings before inserting them. I don't know anything about the magic_quotes_sybase but isn't the escape for an apostrphoe in Oracle another apostrphe? e.g. "this isn't a test" should become "this isn''t a test" I've been doing some Oracle stuff here and that's what I've had to do. Cheers, Graeme