On Sat, Apr 10, 2004 at 06:24:35AM -0400, Chris Faust wrote: > > 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? > > 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?
Seems like a bug in DBD::Sybase, but that's for Michael Peppler to judge. Tim.