Re: sql standard: \' or ''

CSN wrote:
> --- 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