Characters which requires escaping

Started by Antony Paulalmost 22 years ago3 messagesgeneral
Jump to latest
#1Antony Paul
antonypaul24@hotmail.com

Hi all,
What are the characters which requires an escape sequence when used in
the query. I am writing an application using JDBC.

rgds
Antony Paul

#2Peter Eisentraut
peter_e@gmx.net
In reply to: Antony Paul (#1)
Re: Characters which requires escaping

Antony Paul wrote:

What are the characters which requires an escape sequence when
used in the query. I am writing an application using JDBC.

That depends on which part of the query you are talking about.
Different syntactic constructs have different escaping rules.

#3Paul Thomas
paul@tmsl.demon.co.uk
In reply to: Antony Paul (#1)
Re: Characters which requires escaping

On 10/07/2004 14:44 Antony Paul wrote:

Hi all,
What are the characters which requires an escape sequence when used
in
the query. I am writing an application using JDBC.

If youn use PreparedStatements, the driver will do the escaping for you.

HTH

-- 
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for 
Business             |
| Computer Consultants         | 
http://www.thomas-micro-systems-ltd.co.uk   |
+------------------------------+---------------------------------------------+