RE: variables prefix - ?variable vs. $variable

So are you saying ALL '?' get processed, even if in a literal?

How does a client ask query that involves a ? in a string?

	Andy

-------- Original Message --------
> From: Dirk-Willem van Gulik <>
> Date: 31 August 2004 12:50
> 
> On Tue, 31 Aug 2004, Seaborne, Andy wrote:
> 
> > SQL queries can contain ? in other places such as literals. 
> > Presumably use of SQL interface placeholders are determined by some
> > level of parsing, else 
> 
> The issue is that the ? is always handled at the client/language side of
> the *DBC connection. And hence very hard to escape; Using the likes of
> %, !, ~, $ |, ^, & is a lot safer as it is handled on the server side.
> 
> Dw

Received on Tuesday, 31 August 2004 12:15:19 UTC