On Mon, Jan 28, 2002 at 01:06:52PM -0800, Michael Peppler wrote: > Jeff Urlwin writes: > > Dale, > > > > There was a discussion and patch on this a while ago. Honestly, I don't > > remember the specifics but it was determined that a literal should be > > surrounded by " instead of ', but this, I can see, is definitely a > > problem... > > > > I, unfortunately, don't remember why we did this...and I can't seem to find > > the discussion. I can, I think, change it to allow for either: > > "abd" > > or > > 'abd' > > or > > ' this "is a test" ' > > or > > " 'this is a test' " > > (i.e. if you start with a " then it must finish on a " and if you start with > > a ' you must finish with a ') > > That's what Sybase does/allows, *unless* the quoted_identifier option > is set, in which case only single quotes are allowed to quote > literals.
Which is the standard SQL behaviour and recommended if you have a choice. Tim.
