sql standard: \' or ''

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

--- 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.

__________________________________
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs
http://hotjobs.sweepstakes.yahoo.com/careermakeover

--- CSN <cool_screen_name90001@yahoo.com> 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.

er, nevermind, magic_quotes_gpc is doing the \'.

__________________________________
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs
http://hotjobs.sweepstakes.yahoo.com/careermakeover

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

On Wed, 5 May 2004, 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.

Maybe their different versions? an older one that uses \' and a newer one
that uses ''?

Just a guess.