> Do double quotes really need to be doubled when embedded within a > single quoted string? In other words, isn't 'foo"bar' correct for Sybase? > > Are you quoting literal strings or schema identifiers? > > Tim.
Thanks for the reply Tim, I'm quoting literal strings and I'm afraid in this case it does no good to have any double quotes within a single quoted string. For an example: $var = "I'm really wishing that I used "MySQL" as then I can use placeholders". $var = $dbh->quote($var); $var now equals: 'I''m really wishing that I used "MySQL" because I could use placeholders.' If I try to save this to the DB, all that gets saved is everything up until the first double quote, in this case I end up with I'm really wishing that I used If I quote manually so I end up with: 'I''m really wishing that I used ""MySQL"" because I could use placeholders.' Everything goes fine. Any suggestions? Thanks -Chris Complete Thread> > On Fri, Apr 09, 2004 at 01:12:14PM -0400, Chris Faust wrote: > > Hello, > > > > I'm using the combination of DBI, DBD::Sysbase and FreeTDS to connect to an MS-SQL server. > > Due to the issues with placeholders and sp's (specifically not being able to use them), I'm forced to properly deal with any single and double quotes. > > > > It seems like DBI->quote does almost everything correctly with the exception of leaving double quotes unchanged. > > > > Is there some way to get the quoting method to continue to work as it does now but to also change > > > > " > > to > > > > "" > > Do double quotes really need to be doubled when embedded within a > single quoted string? In other words, isn't 'foo"bar' correct for Sybase? > > Are you quoting literal strings or schema identifiers? > > Tim. > > > Thanks! > > -Chris > > > > DBI 1.38 > > DBD::Sybase 1.47 >
