Re: Help needed with standard_conforming_strings

On Thu,  8 May 2008 23:23:42 -0000, "Greg Sabino Mullane"
<greg-738XdyZ4GzZWk0Htik3J/[email protected]> wrote:
> 
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: RIPEMD160
> 
> 
>> Couldn't DBD::Pg just switch to using ' to escape quotes? I mean, the
>> problem is DBD::Pg escaping in $dbh->quote(), is it not? In that case,
>> Just escape ' and not \ if SCS is on.
> 
> No, we can't leave backslashes unescaped: that's a compatiblity can of
> worms I don't want to open. Consider the result of a $dbh->quote() that's
> stored by the app and then reused - but with a different SCS setting!
> 

That is the fault of the application -- A bug, as it were. I don't think 
the driver should be second guessing the user -- It is almost as if the
driver
is telling the user, maybe not not screaming at the top of its lungs, but 
whispering quietly into the users ear, 'I know you turned SCS on but you
are
probably too stupid to use it correctly, so I will do what is best for
you'.

-r