Re: disabling backslash as an escape character in strings

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Christos Karras wrote: > Yes, I use JDBC (with the MySQL Connector/J driver). I did not find a > way in the JDBC API to escape a string before inserting it in a SQL string. > The JDBC PreparedStatement class is able to escape parameters (in a > databa

Re: disabling backslash as an escape character in strings

y to disable the use of the backslash as an escape character in strings? I need to use an application that's designed to work on any database server supporting ANSI SQL. When it generates SQL insert/update queries, it doesn't escape backslashes in strings, because the ANSI SQL standard doe

Re: disabling backslash as an escape character in strings

libraries and go from there. j- k- On Thursday 08 April 2004 01:37 pm, Christos Karras said something like: > Is there a way to disable the use of the backslash as an escape > character in strings? I need to use an application that's designed to > work on any database ser

disabling backslash as an escape character in strings

Is there a way to disable the use of the backslash as an escape character in strings? I need to use an application that's designed to work on any database server supporting ANSI SQL. When it generates SQL insert/update queries, it doesn't escape backslashes in strings, because th

Re: escape character within sql statement.

Hi, where a1="Here's" You need to escape the ' character with a backslash before you send the query to the server. If you develope with C this link might be useful: http://www.mysql.com/doc/en/mysql_real_escape_string.html If you develope wit perl + DBI there comes a quote methode with the DBI pa

escape character within sql statement.

Hi, Following statement was working fine untill recently when someone entered specail characters in insert statement. eg insert in db (col1,col2) values('a1','a2'); where a1="Here's" a2="Your's" thats is when apostrope is applied. Thanks Adamji

re: escape character

Daya, Saturday, November 09, 2002, 2:28:07 PM, you wrote: DKD> Hi can anybody tell me how can i insert rtf data in my sql, since it DKD> contains escape characters DKD> like this DKD> {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 DKD> Verdana;}{\f1\fnil\fcharset2 Webdings;

escape character

Hi can anybody tell me how can i insert rtf data in my sql, since it contains escape characters like this {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Verdana;}{\f1\fnil\fcharset2 Webdings;}{\f2\fnil\fcharset0 MS Sans Serif;}} {\colortbl ;\red0\green0\blue0;\red0\green0\bl

RE: About escape character '\'

thanks a lot, it helps Kathy -Original Message- From: Bill Easton [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 9:44 AM To: [EMAIL PROTECTED] Cc: Kathy Sung Subject: RE: About escape character '\' Sorry, I guess I answered too quickly. You have a problem, if you h

RE: About escape character '\'

th) VALUES (?)"); PreparedStatement ps = con.prepareStatement(sql); ps.setString(1, "c:\\Repository\\Pack\\"); ps.executeUpdate(); Hope that works for you. > Subject: RE: About escape character '\' > Date: Thu, 11 Apr 2002 13:54:46 -0400 > From: "Kathy Sung" <

RE: About escape character '\'

path) VALUES ('c:\\Repository\\Pack\\')" (because in Java '\' is also an escape character) So, in MySQL 'c:\Repository\Pack\' will be inserted, while in MS SQL and Oracle 'c:\\Repository\\Pack\\' will be inserted and that's the problem for me... -Ori

Re: About escape character '\'

INSERT INTO files (filepath) VALUES ('c:\Repository\Pack\' ) so what gets inserted is, in fact, c:\Repository\Pack\ > Subject: About escape character '\' > Date: Wed, 10 Apr 2002 19:44:21 -0400 > From: "Kathy Sung" <[EMAIL PROTECTED]> > To: <[EMAIL

About escape character '\'

\' to escape each of the '\' in the above sql statement. But, the problem is MS SQL and Oracle do not treat '\' as an escape character in sql statements, and I want to keep my Java program as database-independent as possible. (and I don't want the whole string '

escape character question

i, I need to know how to put email addresses into the mysql database without encountering the escape character. All of the email addresses that contain an underscore are receiving a backslash before the underscore. For example, [EMAIL PROTECTED] turns into mike\[EMAIL PROTECTED] This escape

VIRUS FOUND Re: escape character for # sign?

Attention, the original message of Funky Gao and following replies contain the virus W32.Navidad.16896 Antonio

escape character for # sign?

How can I escape the mysql comment # character in sql statements? Thanks, Doug Sherman Emanuel.exe - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the l

Re: escape character for # sign?

IL PROTECTED]] > Sent: Thursday, October 12, 2000 2:43 PM > To: [EMAIL PROTECTED] > Subject: escape character for # sign? > > How can I escape the mysql comment # character in sql statements? > > Thanks, > > Doug Sherman > > -- > ---