An issue in escaping double quote in SQL

[gsoap <gs...@yahoo.com>]

Hi, 

If we escape double quote in SQL by replacing it by two double quotes like
following:

SELECT * FROM nt:base WHERE CONTAINS(., '"This line have "" quote"')

then this does not work in case if we search only " see following query: 

SELECT * FROM nt:base WHERE CONTAINS(., '""""') 

In the above query we have a single term and we are searching only " which
if we replace by "" it results in parser exception. 

Kindly suggest something. 

Thanks. 

-- 
View this message in context: http://www.nabble.com/An-issue-in-escaping-double-quote-in-SQL-tf3900905.html#a11058604
Sent from the Jackrabbit - Users mailing list archive at Nabble.com.