NYCPHP Meetup

[Daniel Convissor]

Hi John:

On Sat, Dec 06, 2003 at 02:37:43PM -0700, John Lacey wrote:
> 
> My question is: hasn't this behavior come up before in light 
> of the fact that SQLite is being included in PHP5?

When escaping "'" without the use of an ESCAPE clause, most DBMS's, and 
perhaps the SQL-99 standard itself, use "''"

MySQL kind of made up it's own thing by doing "\'"  Do note, you can also
use "''" in MySQL (at least in version 4.0, maybe in 3.2x too).

The drag is mysqldump puts "\'" in there.  That should be classified as a 
bug.

--Dan

-- 
     FREE scripts that make web and database programming easier
           http://www.analysisandsolutions.com/software/
 T H E   A N A L Y S I S   A N D   S O L U T I O N S   C O M P A N Y
 4015 7th Ave #4AJ, Brooklyn NY    v: 718-854-0335   f: 718-854-0409