Re: sql standard: \' or ''

From: Bill Moran <wmoran(at)potentialtech(dot)com>
To: CSN <cool_screen_name90001(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: sql standard: \' or ''
Date: 2004-05-05 22:24:15
Message-ID: 4099698F.8090409@potentialtech.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

CSN wrote:
> --- Gregory Wood <gwood(at)ewebengine(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message scott.marlowe 2004-05-05 22:28:59 Re: sql standard: \' or ''
Previous Message CSN 2004-05-05 22:22:33 Re: sql standard: \' or ''