--- Gregory Wood <gwood@ewebengine.com> wrote:
CSN wrote:
I heard that the sql standard for escaping quotes
is
'', and not \'. Is this true?
BTW, PHP's pg_escape_string returns \' and not ''.
Are you sure about that?
~# php -r "print pg_escape_string(\"I can't believe
that quotes are escaped improperly\n\");"
I can''t believe that quotes are escaped improperly
Greg
Weird. Via cgi it escapes them as \' and via cli as '', for me anyway.
Check your php.ini
There are config options to change the behaviour of most escape functions. Off the top of my head, I don't know for sure what settings will affect pg_escape_string() but I'd be willing to be that's the issue.
-- Bill Moran Potential Technologies http://www.potentialtech.com
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster