My apologies for missing the previous discussion and thanks for the info. A follow up
question: is there a performance penalty associated with using PreparedStatement's
with queries that will never be reused? Clearly, there's a performance benefit for
statements executed multiple times, but how does using a PreparedStatement compare
with using a Statement (with a hard coded SQL string) for single use queries?
Thanks in advance,
Alex
==============================================
Hi Alex. This question was discussed last week. Search the archives
for 'backslash'. The short answer is that there is no global option to
do what you want. You'll have to do it in code.
On Mon, 2004-04-12 at 17:10, [EMAIL PROTECTED] wrote:
> Is there a 'global' way to tell MySQL to not interpret the backslashes ('\'s) in the
> submitted SQL as escape characters? In other words, I'd like for them to always be
> treated as if they themselves were already escaped with a backslash (i.e. '\\'). I'm
> using 3.23.52, accessing it with an older (2.x?) MM JDBC driver. I know of a couple
> of
> code-level solutions that will require a number of changes in the existing code, but
> was
> hoping to find a more 'global' solution, via either a global call or a configuration
> setting. Any ideas are much appreciated.
>
> Thanks in advance,
>
> Alex Zeltser
>
>
> __________________________________________________________________
> Introducing the New Netscape Internet Service.
> Only $9.95 a month -- Sign up today at http://isp.netscape.com/register
>
> Netscape. Just the Net You Need.
>
> New! Netscape Toolbar for Internet Explorer
> Search from anywhere on the Web and block those annoying pop-ups.
> Download now at http://channels.netscape.com/ns/search/install.jsp
--
|- Garth Webb -|
|- [EMAIL PROTECTED] -|
__________________________________________________________________
Introducing the New Netscape Internet Service.
Only $9.95 a month -- Sign up today at http://isp.netscape.com/register
Netscape. Just the Net You Need.
New! Netscape Toolbar for Internet Explorer
Search from anywhere on the Web and block those annoying pop-ups.
Download now at http://channels.netscape.com/ns/search/install.jsp
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
